XLOOKUP Formula Error

Question

I'm trying to use a XLOOKUP formula to pull information form other sheets in my document.

It is not returning any information. I have found this is due to the date formula that is in the sheet. Is there a work around for this problem?

Thanks,

Nick

Answer 1

Thanks. I decided to use a work around and change the date formula to just a number.

Answer 2

Hi There ...

I had a look at your file. You are trying to match Number 2 with a date .

So it will not fetch you match using XLOOKUP/HLookup.

You will have to get a Key of same value type.

Answer 3

Hi Nick,

Thanks for providing the workbook, please allow me some time, I'll check the workbook and see if I can find something,

Meanwhile, you can either upload the Office 365 Product Information in the OneDrive link or use the Insert Image button when replying to this post.

Regards,

Neha

Answer 4

I uploaded the sample doc. The formula I am working on is on the Dashboard tab. Should I also put the screenshot in the onedrive you set up?

Answer 5

Hi Nick,

I understand you are getting error using XLOOKUP function to pull data from another sheet.

May I request a sample workbook, so we can try from our side? Please remember to remove all the sensitive information from the workbooks before providing us with the workbook. You can upload the workbook in this OneDrive link.

In addition, please provide a screenshot of Office 365 Product Information. To get this screenshot, open word or Excel on your system, click File>Account, capture the screenshot of all the information mentioned under Product Information.

Regards,

Neha