bro uske liye if statement me thoda change hoga or format me bhi ek cell aur insert hoga yadi laga sako to formula ka sample likh raha hun verna comment me batana is par bhi video bana dunga Formula =vlookup(lookup_value,IF(logical_test,value_if_true,IF(logical_test,value_if_true,IF(logical_test,value_if_true))),column_ind_num,Exact_match) Logical_Test = Jo naya cell lenge wo for example new cell is E4 than =IF(E4="delhi") Value_if_True = table name (or table array)
bro uske liye if statement me thoda change hoga or format me bhi ek cell aur insert hoga yadi laga sako to formula ka sample likh raha hun verna comment me batana is par bhi video bana dunga Formula =vlookup(lookup_value,IF(logical_test,value_if_true,IF(logical_test,value_if_true,IF(logical_test,value_if_true))),column_ind_num,Exact_match) Logical_Test = Jo naya cell lenge wo for example new cell is E4 than =IF(E4="delhi") Value_if_True = table name (or table array)
sir mere office me attendance sheet bnti hai with Ot format example 09.00 18.00 0.5 ot dono shifts chalti hai day or night bhi & weekly shits change bhi hoti hai ot kaise calculate kre koi code ya formula btaye pls
bro aap kya kya calculation karna chahte hain unki kuchh detail vagera ka sample hame batana hoga, sample format hame mail karna hoga sayad hum aapki help kar payen jangirgolums2@gmail.com
By name kaise search karu...22 sheets hai bank ki details and 22 sheets mein manually jana padta hai. Ab 1 sheet mein search karu or uski details aajaye puri
ok bhi thank waise ham vlookup samjha rahe hain, samjhate waqt table me data likhne or spelling mistake ho jati hai lekin jo samjhana chahte hain wo galat nahi karenge koi bhi tutorial utha kar dekh lena. thanks again and u r welcome
Knowledgeable video and easily explained.... thankyou Sir🙏
Superb sir... learn new thing today
Great example, thanks! LIKE
Awesome video sir ji👏👏👏👏👏👍
Too much useful sir 🙏
Excellent Work Bro Keep It up i Modify and Now Using as a Medicines software
Very informative
Great👍👏
Thank you so much
nice sir👌
Excellent Work as a Practice File Also Available
Agar id random ho tab if statment kaise kam karega
Is tarah se formula kam kaise karega
bro uske liye if statement me thoda change hoga or format me bhi ek cell aur insert hoga yadi laga sako to formula ka sample likh raha hun verna comment me batana is par bhi video bana dunga
Formula
=vlookup(lookup_value,IF(logical_test,value_if_true,IF(logical_test,value_if_true,IF(logical_test,value_if_true))),column_ind_num,Exact_match)
Logical_Test = Jo naya cell lenge wo for example new cell is E4 than =IF(E4="delhi")
Value_if_True = table name (or table array)
bro uske liye if statement me thoda change hoga or format me bhi ek cell aur insert hoga yadi laga sako to formula ka sample likh raha hun verna comment me batana is par bhi video bana dunga
Formula
=vlookup(lookup_value,IF(logical_test,value_if_true,IF(logical_test,value_if_true,IF(logical_test,value_if_true))),column_ind_num,Exact_match)
Logical_Test = Jo naya cell lenge wo for example new cell is E4 than =IF(E4="delhi")
Value_if_True = table name (or table array)
ha bhai random mai kam ni kr raha hai ?
Good
It is very useful. But 14:08 designation ke jagah per Farher's name aa raha hai. Lagta kuch galat hua lag raha hai.
Sir,yeh jo video me if condition me apne emp id ke uppar condition lagadiya, excel sheet name me condition laga sakthe ho kya sir,pls reply
Sir pls reply
Sir, file se kaise search karen?
sir mere office me attendance sheet bnti hai with Ot
format example
09.00
18.00
0.5 ot
dono shifts chalti hai day or night bhi & weekly shits change bhi hoti hai ot kaise calculate kre
koi code ya formula btaye pls
bro aap kya kya calculation karna chahte hain unki kuchh detail vagera ka sample hame batana hoga, sample format hame mail karna hoga sayad hum aapki help kar payen
jangirgolums2@gmail.com
@@ComputerGyanGuruji Sir Aapko excel Sheet Mail kr di hai
How to search the same data sheet with name text
If have no series...then...
sir I have doubt
Id ke jagah name se lookup krna hoga tb kaise hoga sir ji plz do the needful Thank you sir.
Sir agar alag alag file me rahega to kaise ksrenge.
same aise hi aayega but formula lagane ke baad un files ki location change mat karna
@@ComputerGyanGuruji lekin sir dusre file me jab jate hai formula lagta nahi hai ???
By name kaise search karu...22 sheets hai bank ki details and 22 sheets mein manually jana padta hai. Ab 1 sheet mein search karu or uski details aajaye puri
th-cam.com/video/Y4x8FJVvKs8/w-d-xo.html
th-cam.com/video/ocTWjPdhzOk/w-d-xo.html
th-cam.com/video/FLLCoNTPqdE/w-d-xo.html
th-cam.com/video/WJ4rPg-BLuE/w-d-xo.html
th-cam.com/video/B_9WRuklsNc/w-d-xo.html
How to consolidate from 15sheets using vlookup
SIR I HAVE SMALL DOUT IN MY DATA SO PLEASE SEND THE MAIL ID, I AM SEND THE SHEET
Manoj sir contact no send karna
Thori si heading ki galti ki hai sir ap na
यह जो आप बनाये है तो कैसे डॉउनलोड करे कृपया भेज दीजिये clyntpc@gmail.com पर मनोज sir बहुत मेहबानी होगी
same formula isme lagaya hai aap yahan se download kar sakte hain
th-cam.com/video/FLLCoNTPqdE/w-d-xo.html
are sir ye kya padha rahe ho designation mai father's name dala huva hai had hai sir
ok bhi thank waise ham vlookup samjha rahe hain, samjhate waqt table me data likhne or spelling mistake ho jati hai lekin jo samjhana chahte hain wo galat nahi karenge koi bhi tutorial utha kar dekh lena. thanks again and u r welcome
@@ComputerGyanGuruji thanx so much koi ni hota hai sir agar id no random ho mtld serial vise na ho to kaise hoga ??
Sir ur rong
how, plz tell me
Yes 7251811028 tell me
@@surajrawat2733 😅😅😅😅