View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Johno Johno is offline
external usenet poster
 
Posts: 16
Default Vlookup cell reference

Thanks, but I checked all of those options. I exported the data from a web
based data warehouse. Out of frustration, I deleted the ID numbers that were
exported and retyped them so I know there are no spaces or other characters.
It still did not work.
--
johno


"T. Valko" wrote:

See if this helps:

http://contextures.com/xlFunctions02.html#Trouble

--
Biff
Microsoft Excel MVP


"Johno" wrote in message
...
I have two spreadsheets, each containing a column of ID numbers common to
both sheets. I am attempting to extract data from one sheet and insert
into
the other sheet using the common ID numbers. My formula is
=Vlookup(A5,A100:X200, 3) where A5 is the ID number I'm referencing on the
first sheet, A100:X200 is the range of data on the second sheet and 3 is
the
column offset. I. get the formula or N/A as a result. If I enter the ID
number in place of the cell reference A5, it works.

The formula works on other spreadsheets so there must be something in this
one that prevents the cell reference from working in vlookup.

Can someone help?


--
johno