Forum Discussion
XLookup Not Finding a Match (when I see that the data is there)
This is about XLookup not working for me. I'm using Microsoft 365 (Excel) in Windows 10 Enterprise I am using XLookup (for the first time) in VBA for an Excel Workbook that I am modifying for w...
I actually have the same problem but i am not using VBA.
My 'lookup values' and 'lookup arrays' are a combination alphabets and numbers in one word. My Xlookup returns some, but not all although I can visually see that the data are there but it not getting picked-up.
Any assistance would be greatly appreciated. Thank you.
My 'lookup values' and 'lookup arrays' are a combination alphabets and numbers in one word. My Xlookup returns some, but not all although I can visually see that the data are there but it not getting picked-up.
Any assistance would be greatly appreciated. Thank you.
You're on the right track. I think you'll find it to be the data types that are not the same in both table columns. If they were both text, you'd likely find success.