CHAPTER 12 · ADVANCED EXCEL
XLOOKUP
XLOOKUP modern Excel ka flexible lookup function hai. Ye left ya right dono direction me lookup kar sakta hai aur not-found result ko directly handle kar sakta hai.
Basic syntax
exact lookupExcel
=XLOOKUP(E2,A2:A5,C2:C5)E2 ko lookup array me find karke return array se corresponding value deta hai.
Not found message
fallbackExcel
=XLOOKUP(E2,A2:A5,C2:C5,"Not Found")Separate IFERROR ki zarurat kai cases me nahi padti.
Hinglish
VLOOKUP me return column number yaad rakhna padta hai; XLOOKUP me lookup range aur result range directly select karte ho, isliye formula readable rehta hai.