ExcelBanter - Vlookup issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup issue (https://www.excelbanter.com/excel-programming/271823-vlookup-issue.html)

I have two files.
The first file has a worksheet called "MAP".
It contains a column of data that I needs to be mapped to
another #.
The second file(lookup1.xls) contains 3 columns, 1st
column is a description, 2nd colum contains a list of
numbers that is represented in the first file, the 3rd
column contaisn the number it is to be mapped to.

So, in this case 'B19' is '1900000', in 'lookup1.xls' the
2nd column contains the number '1900000' and the 3rd
column- same row contains the number '1900'. But all that
show up in the column with this formula is 'False', so in
other words it says that it does not find a match. I have
used vlookup before with much larger files and more
columns with no issues. can anyone see a problem with the
code?
=IF(ISNA(VLOOKUP(MAP!B19,[lookup1.xls]Sheet1!
$A$1:$C$200,3,FALSE)),"False",VLOOKUP(MAP!B19,[lookup1.xls]
Sheet1!$A$1:$C$200,3,FALSE))

Thanks for your help in advance.

Brian Nelligan

Brian,

You need to start lookup in column B don't you

=IF(ISNA(VLOOKUP(MAP!B19,[lookup1.xls]Sheet1!$B$1:$C$200,2,FALSE)),"False",V
LOOKUP(MAP!B19,[lookup1.xls]Sheet1!$B$1:$C$200,2,FALSE))

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks

"Brian Nelligan" wrote in message
...
I have two files.
The first file has a worksheet called "MAP".
It contains a column of data that I needs to be mapped to
another #.
The second file(lookup1.xls) contains 3 columns, 1st
column is a description, 2nd colum contains a list of
numbers that is represented in the first file, the 3rd
column contaisn the number it is to be mapped to.

So, in this case 'B19' is '1900000', in 'lookup1.xls' the
2nd column contains the number '1900000' and the 3rd
column- same row contains the number '1900'. But all that
show up in the column with this formula is 'False', so in
other words it says that it does not find a match. I have
used vlookup before with much larger files and more
columns with no issues. can anyone see a problem with the
code?
=IF(ISNA(VLOOKUP(MAP!B19,[lookup1.xls]Sheet1!
$A$1:$C$200,3,FALSE)),"False",VLOOKUP(MAP!B19,[lookup1.xls]
Sheet1!$A$1:$C$200,3,FALSE))

Thanks for your help in advance.

Brian Nelligan