Vlookup vs Hlookup in Excel

Learn Vlookup Vs Hlookup in Excel in Hindi

Is Video mai aap dekhoge ki:

• VLOOKUP & HLOOKUP mai difference kya hai?
• Kis situation mai aapko Vlookup istamaal karna hai?
• Kis situation mai aapko Hlookup ka sahara lena hai?

You have 2 Tables in Front of you:

Pehla dhyaan Left Side par rakhe:

• Yaha par Vertically, Uppar se Niche(Top to Bottom) Company Name hai
• Inke Sales k Numbers hai
• Inke Cost bhi hai

If Anyone Ask you:

Blue Company k Cost k baare mai mujhe bataye?

(Company Name=Blue→Cost=?)

Toh chaliye dosto, mai aapko batata hu kaise karte hai:

1. Type  ⇒ {=VLOOKUP}
2. Lookup Value → Select Blue(D4 Cell) ⇒ {=VLOOKUP(D4,}
3. Table Array → Select Whole Table(B7:D12) ⇒ {=VLOOKUP(D4,B7:D12}
4. Press F4 → Taaki Table Freeze or Lock hojaye ⇒ {=VLOOKUP(D4,$B$7:$D$12,}
5. Column Index No. → 3rd Column ⇒ {=VLOOKUP(D4,$B$7:$D$12,3,}
6. Range Lookup → False/0(Exact Match) ⇒ {=VLOOKUP(D4,$B$7:$D$12,3,0)}
7. Press ENTER↵

Answer aagya bhaiya, Company Name=Blue→Cost=9,400

Ye tha Basic Vlookup ⇑

Par dosto, yehi same data ko mene Transpose kia hai:

1. Select kare ⇒ Pure Table ko Copy Kare
2. Dusre Cell par ⇒ Right Click kare
3. Click kare ⇒ Paste Special par
4. Tick kare ⇒ Transpose Checkbox par
5. Press OK

Waah bhaiya, jo chiz uppar se niche dikhaai gyi thi vo Side Ways aagyi hai

Toh dosto, aapko Lookup Value k jariye, Uppar se Niche Side Ways dekhna ho?

Toh  kehlata hai Horizontal Lookup(HLOOKUP):

1. Type ⇒ {=HLOOKUP}
2. Lookup Value → Select Blue(G4 Cell) ⇒ {=HLOOKUP(G4,}
3. Table Array → Select Whole Table(F7:K9) ⇒ {=HLOOKUP(G4,F7:K9}
   (Note: 1st Row aisa ho, jaha aapko Lookup Value paya jaa sake)
4. Press F4 → Taaki Table Freeze hojaye ⇒ {=HLOOKUP(G4,$F$7:$K$9}
5. Row Index No. → 3rd Column(Cost 3rd Row mai hai) ⇒ {=HLOOKUP(G4,$F$7:$K$9,3}
6. Range Lookup → False/0(Exact Match) ⇒  {=HLOOKUP(G4,$F$7:$K$9,3,0)}
7. Press ENTER↵

Answer aagya bhaiya, Same Answer aaya jo Vlookup ne dikhaya tha, Company Name=Blue→Cost=9,400

Toh dosto, ye tha VLOOKUP & HLOOKUP ka Basic difference:

• Data agar Vertically Placed hai toh ⇒ VLOOOKUP
• Same ID Codes ya Common Link Horizontally Placed hai toh ⇒ HLOOKUP

Toh Dosto,

• Humare Excel Videos dekhte rahiye:
• Sikhte rahiye
• Sikhate rahiye
• Or baniye Excel Superstar.