| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup to return cell position as to where result was found
I would like to run a vlookup for a name and have it return the location of
the cell where it finds it so I can use it in a sum(offset()) function. column A row 1 Sam row 2 Bill row 3 Eva Vlookup( EVA,A1:C3,location Cell) would like result to be A3 -- Thanks Roch |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use vlookup to return a formula not a result | Excel Worksheet Functions | |||
| vlookup untill a vaule is found then automaticaly paste the result | Excel Worksheet Functions | |||
| Vlookup, return zero if not found | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| vlookup to return the cell positioning where the criteria is found | Excel Programming | |||
Threaded Mode
