lookup problem
 

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

lookup problem
 

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

lookup problem
 

thanks thats what i figured but it just aint playing the game yet



"Tom Ogilvy" wrote:

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