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

КОМЕНТАРІ • 44

  • @nehajoshi8780
    @nehajoshi8780 Рік тому

    Knowledgeable video and easily explained.... thankyou Sir🙏

  • @starmakersinger7453
    @starmakersinger7453 3 роки тому

    Excellent Work Bro Keep It up i Modify and Now Using as a Medicines software

  • @ExcelVisual
    @ExcelVisual 4 роки тому +2

    Great example, thanks! LIKE

  • @inderjain7035
    @inderjain7035 3 роки тому

    Superb sir... learn new thing today

  • @saket4789
    @saket4789 Рік тому

    Too much useful sir 🙏

  • @rooneychauhan7718
    @rooneychauhan7718 3 роки тому

    Awesome video sir ji👏👏👏👏👏👍

  • @starmakersinger7453
    @starmakersinger7453 3 роки тому

    Excellent Work as a Practice File Also Available

  • @yasmeenhussain1067
    @yasmeenhussain1067 Рік тому

    Very informative

  • @mdsani743
    @mdsani743 5 місяців тому

    Thank you so much

  • @himanshubhatia4028
    @himanshubhatia4028 4 роки тому +1

    nice sir👌

  • @yasmeenhussain1067
    @yasmeenhussain1067 Рік тому

    Great👍👏

  • @AbhishekMishra-cr1tz
    @AbhishekMishra-cr1tz 4 роки тому +3

    Agar id random ho tab if statment kaise kam karega
    Is tarah se formula kam kaise karega

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  4 роки тому

      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)

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  4 роки тому

      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)

    • @paramjeet975singh3
      @paramjeet975singh3 4 роки тому

      ha bhai random mai kam ni kr raha hai ?

  • @sarvodayaconventvidisha1757
    @sarvodayaconventvidisha1757 4 роки тому +1

    Good

  • @vishwastoraskar
    @vishwastoraskar 11 місяців тому

    It is very useful. But 14:08 designation ke jagah per Farher's name aa raha hai. Lagta kuch galat hua lag raha hai.

  • @yadhukrishnan8299
    @yadhukrishnan8299 3 роки тому

    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

  • @himanshubhatia4028
    @himanshubhatia4028 4 роки тому +1

    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

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  4 роки тому

      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

    • @himanshubhatia4028
      @himanshubhatia4028 4 роки тому

      @@ComputerGyanGuruji Sir Aapko excel Sheet Mail kr di hai

  • @BalvirSingh-qs9kz
    @BalvirSingh-qs9kz 7 місяців тому

    Sir, file se kaise search karen?

  • @ankitsinghshengar7653
    @ankitsinghshengar7653 3 роки тому

    Id ke jagah name se lookup krna hoga tb kaise hoga sir ji plz do the needful Thank you sir.

  • @surajbhawnani6935
    @surajbhawnani6935 3 роки тому

    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

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  3 роки тому

      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

  • @NitinSharma-hm5ms
    @NitinSharma-hm5ms Рік тому

    How to search the same data sheet with name text

  • @abirskeyboardplay8620
    @abirskeyboardplay8620 3 роки тому

    How to consolidate from 15sheets using vlookup

  • @minakshinegi2571
    @minakshinegi2571 3 роки тому

    sir I have doubt

  • @arjun.kumar16654
    @arjun.kumar16654 Рік тому

    SIR I HAVE SMALL DOUT IN MY DATA SO PLEASE SEND THE MAIL ID, I AM SEND THE SHEET

  • @TINKUKUMAR-hl7sz
    @TINKUKUMAR-hl7sz 4 роки тому

    Sir agar alag alag file me rahega to kaise ksrenge.

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  4 роки тому

      same aise hi aayega but formula lagane ke baad un files ki location change mat karna

    • @TINKUKUMAR-hl7sz
      @TINKUKUMAR-hl7sz 4 роки тому

      @@ComputerGyanGuruji lekin sir dusre file me jab jate hai formula lagta nahi hai ???

  • @waseemakhtar9860
    @waseemakhtar9860 7 місяців тому

    Thori si heading ki galti ki hai sir ap na

  • @Yadav-by7ob
    @Yadav-by7ob 3 роки тому

    Manoj sir contact no send karna

  • @CHHEDILAL261
    @CHHEDILAL261 3 роки тому

    यह जो आप बनाये है तो कैसे डॉउनलोड करे कृपया भेज दीजिये clyntpc@gmail.com पर मनोज sir बहुत मेहबानी होगी

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  3 роки тому

      same formula isme lagaya hai aap yahan se download kar sakte hain
      ua-cam.com/video/FLLCoNTPqdE/v-deo.html

  • @paramjeet975singh3
    @paramjeet975singh3 4 роки тому

    are sir ye kya padha rahe ho designation mai father's name dala huva hai had hai sir

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  4 роки тому

      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

    • @paramjeet975singh3
      @paramjeet975singh3 4 роки тому

      @@ComputerGyanGuruji thanx so much koi ni hota hai sir agar id no random ho mtld serial vise na ho to kaise hoga ??

  • @surajrawat2733
    @surajrawat2733 4 роки тому +1

    Sir ur rong