How to do a Vlookup in Excel | Part 3

Learn: Excel VLOOKUP in hindi [Part #3]

Agar aapne humara Pehla do(2) Video dekha hoga Vlookup Basics ka, tab ye Sawal aapko bohot Dilchast lagega.

Logo ne alag alag Scores paaye hai, jaise ki:

  1. Jignesh Bhai=88
  2. Sourav Dada=92
  3. Mogambo=100
  4. Rishabh=45

Abb, Refrence Table banauga:

Mai chahta hu ki jissko,

  • 0-50 aaya vo → Average likha aaye
  • 51-89 aaya vo → Good likha ho
  • 90-99 aaya vo → V. Good likha ho
  • 100 aaya vo → Excellent

Abb aapke mun mai Sawal aarha hoga ki, shayad mai IF(Formula) use karne wala hu

Par Nahi, usme bohot Time lagea, qki mai nahi chahta aap itni mehnat kare.

Hum aur aap Excel Superstar ki tarah, iss problem ko solve karege.

Mai ek(1) Column banauga:

  • 0
  • 51
  • 90
  • 100

Ye⇑ mene Refrence Table k Pehle Digits ko bahar leta hu.

Ye⇓ humari aur aapki bhasha hai:

  • 0-50
  • 51-89
  • 90-99
  • 100

Excel ki bhasha kuch aisi⇓ hai:

Jaha Series mai likho ho >=(More then Equal to)

  • >= → 0
  • >= → 51
  • >= → 90
  • >= → 100

Chaliye Dosto, maje ki baat dekhiye:

Note: Jo Lookup Value aapne Choose kiya hai vo Lookup Value aapko pehle Column mai paaya jaaye, agar aapne table usske pehle waale Column par se select karoge toh aapko Answer nahi milega(Refer this Post)

 

  1. Type kijiye ⇒ {=VLOOKUP(}
  2. Lookup Value → Test ka Score(88) ⇒ {=VLOOKUP(D5,}
  3. Table array → Select Refrence Table ⇒ {=VLOOKUP(D5,G4:I7}
  4. Press F4 → Taaki Table sarke nahi ⇒ {=VLOOKUP(D5,$G$4:$I$7,}
  5. Column Index No. → 3rd Column ⇒ {=VLOOKUP(D5,$G$4:$I$7,3,}
  6. Range Lookup → False True Likhna hai ⇒ {=VLOOKUP(D5,$G$4:$I$7,3,true)}

Waah Bhaiya, Anwer mil gaya 88=Good.

Microsoft kehta jarur hai ki True-Approximate Match hai

But, iska sahi matlab tab nikal k aata hai, jab teen(3) Condition ho aaapke pass:

  1. >= k logic mai aap numbers ko likhe ek(1) column mai
  2. Vo numbers jo aap likh rahe ho vo Accending Order mai rahe
  3. Unka matlab aisa ho ki usme Slabs ho (Slabs ⇒ 0-50, 51-89, 90-99)

Note: Agar aapke pass Slab wala Data na ho, toh aap True ekdhum se use mat kijiye

Toh Dosto, ye hai inshort Vlookup with True, much better than IF(Formula).

Previous Vlookup | Next Vlookup