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?

Full Excel Course in Hindi
(Company Name=Blue→Cost=?)
Toh chaliye dosto, mai aapko batata hu kaise karte hai:
- Type ⇒ {=VLOOKUP}
- Lookup Value → Select Blue(D4 Cell) ⇒ {=VLOOKUP(D4,}
- Table Array → Select Whole Table(B7:D12) ⇒ {=VLOOKUP(D4,B7:D12}
- Press F4 → Taaki Table Freeze or Lock hojaye ⇒ {=VLOOKUP(D4,$B$7:$D$12,}
- Column Index No. → 3rd Column ⇒ {=VLOOKUP(D4,$B$7:$D$12,3,}
- Range Lookup → False/0(Exact Match) ⇒ {=VLOOKUP(D4,$B$7:$D$12,3,0)}
- 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:
- Select kare ⇒ Pure Table ko Copy Kare
- Dusre Cell par ⇒ Right Click kare
- Click kare ⇒ Paste Special par
- Tick kare ⇒ Transpose Checkbox par
- 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):
- Type ⇒ {=HLOOKUP}
- Lookup Value → Select Blue(G4 Cell) ⇒ {=HLOOKUP(G4,}
- Table Array → Select Whole Table(F7:K9) ⇒ {=HLOOKUP(G4,F7:K9}
(Note: 1st Row aisa ho, jaha aapko Lookup Value paya jaa sake) - Press F4 → Taaki Table Freeze hojaye ⇒ {=HLOOKUP(G4,$F$7:$K$9}
- Row Index No. → 3rd Column(Cost 3rd Row mai hai) ⇒ {=HLOOKUP(G4,$F$7:$K$9,3}
- Range Lookup → False/0(Exact Match) ⇒ {=HLOOKUP(G4,$F$7:$K$9,3,0)}
- 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.
Leave a Reply