Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Celll Address Lookup
I have a list of cell addresses to be looked-up by their ids in column
A and B: 1,F1 2,M31 3,G6 etc. now, what I want to do is create a lookup formula that will take the integer result from a cell D3 and lookup the value in the cell that corresponds with that integer. I tried: =cell("contents", vlookup(D3, A:B,2,false)) but that doesn't work because the vlookup returns a string. All help will be greatly appreciated. Thanks, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
Getting a cell address from Vlookup function in a macro? | New Users to Excel | |||
Lookup problem | Excel Worksheet Functions | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup function help | Excel Worksheet Functions |