BrounStack
Learning›Excel Tutorial›INDEX + MATCH
CHAPTER 13 · ADVANCED EXCEL

INDEX + MATCH

INDEX result range se value return karta hai aur MATCH position find karta hai. Dono ko combine karke flexible, column-number-free lookup ban sakta hai.

English + Hinglish35 minBrowser practice

MATCH position find karta hai

positionExcel
=MATCH(E2,A2:A5,0)

0 exact match ko represent karta hai.

INDEX result return karta hai

value by positionExcel
=INDEX(C2:C5,2)

Combine both

flexible lookupExcel
=INDEX(C2:C5,MATCH(E2,A2:A5,0))
Hinglish

MATCH pehle row position dhoondhta hai; INDEX us position par result range ki value deta hai. Table me columns insert hone par ye pattern VLOOKUP se zyada robust ho sakta hai.

Practice

MATCH, INDEX aur combined INDEX+MATCH Excel Lab me solve karo.

Open Excel Lab →