Use Match. It returns the position of the matched cell within the range
searched.

--
Regards,
Tom Ogilvy

"Rich" wrote in message
...
is it possible to get the cell address of a vlookup result
i have a list of data that vlookup runs threw and i want cell

d1 to read the results of vlookup + 1 row
e1 to read the results of vlookup + 2 rows

ect ect