Excel VLOOKUP issue

Question

I have a problem on a VLOOKUP function in an Excel. Basically i am trying to search a route from another spreadsheet, using a reference number. - example: I put in a reference (lets say WPC 80) and i want to get a route (for this ex it should be Pitesti - Wrzesnia:

The problem is that it gives me something random. I know that maybe im not using it correctly, but do you have any idea?

Thank you!

Answer 1

As noted in VLOOKUP documentation, the last parameter contols whether to use Exact Match or Approximate Match.

Try using exact matching:

=VLOOKUP(..., FALSE)

Answer 2

Sorry not enough rep to post a comment. When using vlookup, and the Range_Lookup parameter is TRUE, the lookup table must be sorted in ascending order, or you will get unusual results. Also ensure you put an absolute reference on the lookup table for when you drag it down.

Answer 3

Better use INDEX and MATCH combination, faster and far more reliable.