Forum Discussion

Copper Contributor

May 02, 2022

Excel Sheet is Showing the formula and not the results for Xlookup

I have been having trouble recently getting Xlookup to work. I put in the cell this formula: =XLOOKUP(C2,[catalog.xlsx]Items!$F:$F,[catalog.xlsx]Items!$C:$C) C2= is an SKU (text data) I wa...

excel

mtarler

Silver Contributor

May 03, 2022

CandleStore please check if 'Show Formulas' is turned on (as illustrated here:

If so, turn that off.

CandleStore
Copper Contributor
May 03, 2022
Thank you for your information, I opened a new workbook and then got it to work. I am not sure if that was the problem as I deleted the old workbook that was giving me the problem when I got the new one to work. Thank you again.