Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup issue
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup issue
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup issue | Excel Worksheet Functions | |||
Vlookup issue | Excel Worksheet Functions | |||
VLOOKUP Issue | Excel Worksheet Functions | |||
Another issue with vlookup | Excel Discussion (Misc queries) | |||
vlookup issue | Excel Worksheet Functions |