If you haven't yet moved over to XLOOKUP., you may ask...
Why won't my Vlookup work?
You see the information in the table you're pulling from.
It's there.
Why does your Vlookup formula not work? Why isn't it pulling the information?
Here are the questions you should ask yourself:
Are there any extra spaces in the cells you're pulling from in your data set or in your lookup value?
Is one table formatted as numbers and the other formatted as text, or a mixed bag of formatting?
Did you properly anchor both your array and the lookup value?
Are you automatically recalculating the worksheet?
Comments