CHAPTER 11 · ADVANCED EXCEL

VLOOKUP & HLOOKUP

Lookup formulas ek table me key dhoondh kar related value return karte hain. VLOOKUP vertical tables ke liye aur HLOOKUP horizontal layouts ke liye use hota hai.

English + Hinglish35 minBrowser practice

VLOOKUP syntax

vertical lookupExcel

=VLOOKUP(E2,A2:C5,3,FALSE)

E2 ki value ko A2:A5 me search karke table ke third column se exact result return karega.

Exact match kyun?

Beginner aur business datasets me exact lookup ke liye last argument FALSE use karna safest hota hai. Approximate match tabhi use karo jab sorted ranges aur banded values samajh rahe ho.

HLOOKUP

horizontal lookupExcel

=HLOOKUP(B5,B1:E3,3,FALSE)

Top row me key dhoondh kar specified row se matching value return karta hai.

Hinglish

Socho product code diya hai aur price chahiye. VLOOKUP code ko first column me dhoondhega aur same row ka price return karega.

Practice

VLOOKUP aur HLOOKUP dono ke guided challenges Excel Lab me available hain.

Open Excel Lab →

Next: Modern lookup ke liye XLOOKUP.