Vlookup from multiple sheets in one sheet in excel In Hindi || only one lookup
Вставка
- Опубліковано 25 сер 2024
- Excel VLOOKUP formula with Multiple sheets | vlookup in Excel in Hindi, Use the Excel Vlookup Function across Multiple sheets, Vlookup Magic Trick | ये Smart Vlookup जरूर सीखें | Vlookup in Excel in Hindi
#vlookup #excellookup #vlookupinexcel #msexcel
Practise File Link:
drive.google.c...
Blogger Searies play list link Our second channel
• About Blogger
Vlookup in excel
• Vlookup in excel in hi...
Double Vlookup
• Video
Vlookup Magic
• Vlookup Magic ||Trick ...
Vlookup With multiple criteria
• VLOOKUP with Multiple ...
Vlookup for multiple columns
• vlookup for multiple c...
Student table
• How to Create Student ...
www.amazon.in/shop/computergyanguruji
MS Excel Videos
• Hindi English Dictiona...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
Knowledgeable video and easily explained.... thankyou Sir🙏
Excellent Work Bro Keep It up i Modify and Now Using as a Medicines software
Great example, thanks! LIKE
Superb sir... learn new thing today
Too much useful sir 🙏
Awesome video sir ji👏👏👏👏👏👍
Excellent Work as a Practice File Also Available
Very informative
Thank you so much
nice sir👌
Great👍👏
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 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
Sir, file se kaise search karen?
Id ke jagah name se lookup krna hoga tb kaise hoga sir ji plz do the needful Thank you sir.
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
ua-cam.com/video/Y4x8FJVvKs8/v-deo.html
ua-cam.com/video/ocTWjPdhzOk/v-deo.html
ua-cam.com/video/FLLCoNTPqdE/v-deo.html
ua-cam.com/video/WJ4rPg-BLuE/v-deo.html
ua-cam.com/video/B_9WRuklsNc/v-deo.html
How to search the same data sheet with name text
How to consolidate from 15sheets using vlookup
sir I have doubt
SIR I HAVE SMALL DOUT IN MY DATA SO PLEASE SEND THE MAIL ID, I AM SEND THE SHEET
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 ???
Thori si heading ki galti ki hai sir ap na
Manoj sir contact no send karna
यह जो आप बनाये है तो कैसे डॉउनलोड करे कृपया भेज दीजिये clyntpc@gmail.com पर मनोज sir बहुत मेहबानी होगी
same formula isme lagaya hai aap yahan se download kar sakte hain
ua-cam.com/video/FLLCoNTPqdE/v-deo.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 😅😅😅😅