| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup cell reference
What formula can I use to return a cell number that a vlookup output
references. For instance: Data in A1:A3 = X,Y,Z Cell B1= X Cell C1=vlookup(A1,A1:A3,3,false) Out put should be "Z". I want D1 to be the cell number of "Z". I want my output to be "A3". What am I missing? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup and a Cell Reference | Excel Worksheet Functions | |||
| VLOOKUP using cell reference | Excel Worksheet Functions | |||
| How do I get the cell address of a VLOOKUP reference? | Excel Worksheet Functions | |||
| Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions | |||
| use a cell to reference a range in a vlookup | Excel Discussion (Misc queries) | |||
Threaded Mode
