| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup cell reference
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup cell reference | Excel Discussion (Misc queries) | |||
| VLookup and a Cell Reference | Excel Worksheet Functions | |||
| VLOOKUP using cell reference | Excel Worksheet Functions | |||
| How do I find the cell reference for a vlookup? | Excel Worksheet Functions | |||
| use a cell to reference a range in a vlookup | Excel Discussion (Misc queries) | |||
Threaded Mode
