vlookup to return cell position as to where result was found
see your previous post for two answers
"Rock" wrote in message
...
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
|