Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 620
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup issue Connor Doyle Excel Worksheet Functions 2 February 4th 10 02:52 AM
Vlookup issue Sri Harsha[_2_] Excel Worksheet Functions 2 February 5th 09 07:51 AM
VLOOKUP Issue Rocco2526 Excel Worksheet Functions 2 December 3rd 08 09:54 PM
Another issue with vlookup Arain Excel Discussion (Misc queries) 1 October 19th 07 07:15 PM
vlookup issue Joe Excel Worksheet Functions 1 October 5th 06 07:33 PM


All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"