J
Johno
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?
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?