Forum Discussion

CandleStore's avatar
CandleStore
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 want to match from a different sheet in the same workbook

[catalog.xlsx]Items!$F:$F = this is the column on the Spreadsheet Items that has the SKU (Text Data)

[catalog.xlsx]Items!$C:$C = this is the column from which the cell is that I need the data returned

 

I believe I have everything correct because the Helper Formula box gives the correct result, but when I hit enter, my cursor goes to the cell below it and the formula stays and the result does not get populated.  See pictures below:

 

After hitting <Enter> my cursor is at the Green box with Formula still in the cellRed Circles show the Result that should be where the formula is

 

Any help would be appreciated, I am using a subscription based Office 365 Family account if that matters.

2 Replies

    • CandleStore's avatar
      CandleStore
      Copper Contributor
      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.

Resources