Issue with VLOOKUP.

[jtedmonson42]

So I'm trying to return what is basically a score by looking up an ID and matching it. I condensed two sheets to one table to draw what I need. The issue I thought I was having was that the ID numbers were preceded by letters to distinguish what type of ID. Example ABC 12345678. So I used....

=IFERROR(RIGHT(YMS!G4, LEN(YMS!G4)-SEARCH(" ", YMS!G4,1)), "") to cut out the identifier letters at the beginning. Now when I use the following VLookup I'm getting a n/a error.

=VLOOKUP(C4,Export!$A$1:$F$75,4,FALSE).


So is the problem that even with the formula to only pull the numbers is there the VLOOKUP is still looking for the original value?

Thanks.

 

[Marcelo Branco]

The RIGHT function returns a text, not a number. See if this works

=VLOOKUP(--C4,Export!$A$1:$F$75,4,FALSE)

M.

 

[jtedmonson42]

That did it. Thank you.