Having trouble with VLOOKUP

[pwl2706]

Hi,

I have a column of values of 6 digit numbers, formatted in the cells as numbers. These come from a formula so

=LEFT(RIGHT(B:B,24),6)

returns 327549 in column F.

I would like to find out which of these numbers are also in column G in another sheet called ISA in the same workbook. There is at least 1 match, so I put this VLOOKUP formula in column G on my sheet:

=VLOOKUP(F2,ISA!A1:K8244,7,FALSE)

But all I get is a

#N/A

error.

If I do a CTRL-F search in the ISA sheet, using 327549 it is found in cell G7288

what could I be doing wrong, and is there a better way?

thanks

Philip

 

[VoG]

Try

=VLOOKUP(F2+0,ISA!A1:K8244,7,FALSE)

 

[pwl2706]

thank you, that was it, working great now...