Xlookup not working

Question

HayleyHatzi Author

Level 1

13 points

Xlookup not working

Hi there. One of my formulas isn't working and I can't work out why. Any ideas?

iMac (M3, 2023)

Posted on Sep 11, 2024 12:31 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,562 points

Sep 11, 2024 5:02 AM in response to HayleyHatzi

HayleyHatzi wrote:

The size is not always a number, it could be XL, so do you suggest automatic?

XLOOKUP(search-value,search-range,return-range,if-not-found)

Make sure search-value and search-range are not different data formats.

Automatic works in many cases, but In your case setting both search-value and search-range to Text is probably the most reliable approach.

SG

Reply

Answer 2

Badunit

Level 7

30,732 points

Sep 11, 2024 4:32 AM in response to HayleyHatzi

It may not return a value if G2 is text and G3:P3 has actual numbers (or vice versa).

Reply

Answer 3

HayleyHatzi Author

Level 1

13 points

Sep 11, 2024 2:14 PM in response to SGIII

Perfect. That did the trick. I just made the cells into text and it worked fine. Thanks for all your help.

Reply

Answer 4

HayleyHatzi Author

Level 1

13 points

Sep 11, 2024 4:50 AM in response to Badunit

Thank you so much for your reply. Just to clarify each cell needs to be formatted the same, example either automatic or numbers? The size is not always a number, it could be XL, so do you suggest automatic? I’m sure this worked in the past, just don’t know what has changed?

Reply

Xlookup not working

Similar questions