Thanks Leo, that was it. Even though I had formatted the row for number, it
still treated it as text.
--
johno


"LesG" wrote:

Hi Johno,
when I get this error, it is usually because one of the lookup up cells is
recognisd as text and the other numeric... I am assuming the ID numbers are
numeric only.

To get around this, I usually am succesful with =Vlookup(A5*1,A100:X200, 3,
false) ... the *1 usually converts the "string" number to a number

"Johno" wrote:

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