XLOOKUP Formula (Excel 2021 / 365 ke liye)

Описание: 🟩 XLOOKUP Formula (Excel 2021 / 365 ke liye)

=XLOOKUP(B14, B5:B10, D5:D10, "No Price Found")

Explanation:

B14 → Lookup value (item name jiska price chahiye)

B5:B10 → Lookup range (item list)

D5:D10 → Return range (price list)

"No Price Found" → Agar item nahi milta to ye message show marega
📊 Example Table:

Item Category Price

Apple Fruit 100.00
Banana Fruit 75.00
Carrot Vegetable 50.00
Tomato Vegetable 80.00
Chicken Meat 300.00
Fish Meat 450.00

#Excel2019
#XLOOKUP
#VLOOKUP
#ExcelFormula
#ExcelTips
#ExcelTricks
#LearnExcel
#MicrosoftExcel
#ExcelFunctions
#DataLookup