My Excel is an Idiot

Question

So, I'm using vlookup, but it won't work. It's just a simple formula really.
If you think there is a problem with the source data, there is the screenshot of the source data.

This is the formula i'm using

I have tried everything like rewriting both cells, but still nothing happens.

Do I need to uninstall Excel app and find better apps?

Answer 1

I think that is because you forget to put the range lookup in the formula. Without it, the results will be on random, I guess.

Answer 2

Thanks for sharing the details, jordy!

Check for spaces within the cell, or use trim to remove extra spaces.

Best regards,
Kimberly