="A"&match("Eva",A1:A3,0)

but that wouldn't be useful for the offset function

maybe something like
=sum(offset($A$1,match("Eva",$A$1:$A$3,0)-1,1,1,10))

would sum B3:K3

--
Regards,
Tom Ogilvy


"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