| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell, vlookup, same values
Based on your example, try this formula in D5:
=CELL("address",OFFSET(A1,MATCH(C5,A2:A4,FALSE),1) ) I'm sure there is an easier or more elegant solution, but this seems to return the cell address B3 as you requested. Regards, Steve Hieb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Cell value with multiple values to vlookup | Excel Worksheet Functions | |||
| returning multiple cell values from a vlookup | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
| VLookup to sum cell values | Excel Worksheet Functions | |||
Threaded Mode
