How to do a Vlookup in Excel | Part 5

Learn: How to use Vlookup Function in Excel

Iss Video mai hum discuss karege ki, Vlookup Formula likhne k bavajud #N/A q aate hai Data mai?

Humare pass ek Table hai, jisme diye hai:

Mai chahta hu, mujhe ye⇓ Chaar(4) ID ka Name dekhne mile:

Mai Vlookup() likhuga, qki ek number k jariye mai unke Details Extract kar sakta hu.

Problem ye hai dosto ki, kabhi kabhi hum Technique bhul jate hai iss raste mai aur hume milta hai #N/A.

Toh chaliye dosto, dekhte hai iss baar hum kaha kaha atakte hai?

  1. Type ⇒ {=VLOOKUP(}

  2. Lookup Value → Choose Emp ID(9821181333) ⇒ {=VLOOKUP(H6,}
  3. Table Array → Select from Emp ID to Age Table(Cell C3 to F15) ⇒ {=VLOOKUP(H6,C3:F15,}
    1. 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)
  4. Column Index No. → 2(2nd Column) ⇒ {=VLOOKUP(H6,C3:F15,2,}
  5. Match Type → False(Exact Match) ⇒ {=VLOOKUP(H6,C3:F15,2,False)}
  6. Press ENTER↵
  1. Type ⇒ {=VLOOKUP(}
  2. Lookup Value → Choose Emp ID(9821181333) ⇒ {=VLOOKUP(H6,}
  3. Table Array → Select from Emp ID to Age Table(Cell C3 to F15) ⇒ {=VLOOKUP(H6,C3:F15,}
    1. 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)
  4. Column Index No. → 2(2nd Column) ⇒ {=VLOOKUP(H6,C3:F15,2,}
  5. Match Type → False(Exact Match) ⇒ {=VLOOKUP(H6,C3:F15,2,False)}
  6. Press ENTER↵

Waah bhaiya, pehla Answer mil ya 9821181333 = Hobbs,Pasty

Agar mai usko Copy+Paste karu, toh Answer aayega #N/A

Toh chaliye dosto dekhte hai aisa q aarha hai?

  1. 8322222222 ye #N/A q dikha raha hai?
    1. Qki, ye Data Table mai hai he nahi.
    2. Toh ye Genuine #N/A hai
  2. 9831012345 ye #N/A q dikha raha hai?
    1. Qki, vo Cell Text Format mai hai/ (‘)←ye Character uss Cell mai hai
    2. Cell ko Select kare
    3. Click kare → Convert to Number
      1. Answer aagya 9831012345 = Swann,Trina
  3. 9000122111 ye #N/A q dikha raha hai?
    1. Qki, tab tak Table Array niche khisak gaya hai ⇒ REFER
    2. Pehle Formula mai jaaiye
    3. Choose Kare Table Array Formula ko ⇒ C3:F15
    4. Press F4 ⇒ {=VLOOKUP(H6,$C$3:$F$15,2,False)}
    5. Press ENTER↵
    6. Vahi Formula Copy+Paste kariye Niche ki taraf
      1. Answer aagya 9000122111 = Thomas, Phillis.

Ek Answer isisliye nahi, qki vo Number hai he nahi Data mai.

Toh dosto, Vlookup jaan na achi baat hai, par Vlookup k kaaran kya kya galtiya hosakti hai?

Unhe bhi dhyan rakhe, agar nahi rakhege toh aapke Data mai galat numbers aayege.

Previous Vlookup