You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi there. One of my formulas isn't working and I can't work out why. Any ideas?
iMac (M3, 2023)
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?
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
It may not return a value if G2 is text and G3:P3 has actual numbers (or vice versa).
Perfect. That did the trick. I just made the cells into text and it worked fine. Thanks for all your help.
Xlookup not working
