J

#### Johno

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?