Broken Vlookup (No Match)

TAbs

My vlookup is returning no match even though there is a match avaliable.

But the reference sheet has an avaliable rate:

Colleen Patterson

@TAbs

Your Vlookup range contains both the SO # and the desired result, with the result being in the 2nd column, is that correct?

Also, are both columns formatted the same way, and include no extra spaces / etc, that would be throwing the returned value off?

TAbs

Yes, they have the same info and are formatted the same way - no additional spaces.

Genevieve P.

Hi @TAbs

I notice that in one sheet for your matching values, your numbers appear on the right (indicating they're seen as numerical) whereas in the other sheet the numbers are displaying on the left side of the cell (indicating they're seen as text).

Can you try translating the current sheet's number into a text value, to see if this then finds a match?

=VLOOKUP([SO #]@row + "", {range...etc...

Cheers,

Genevieve

TAbs

Great, that worked!