plz check xllokup formula in attached file and correct it. i have excel 2007
A arifanmol Member Jun 1, 2021 #1 plz check xllokup formula in attached file and correct it. i have excel 2007 Attachments xlookup.xlsx 7.7 KB · Views: 4
Chihiro Excel Ninja Jun 1, 2021 #2 Excel 2007 does not have XLOOKUP formula. That's your problem XLOOKUP is only available for MS365 subscription. Use other lookup type formula construct (Ex: INDEX/MATCH, VLOOKUP etc).
Excel 2007 does not have XLOOKUP formula. That's your problem XLOOKUP is only available for MS365 subscription. Use other lookup type formula construct (Ex: INDEX/MATCH, VLOOKUP etc).