It's better to get it like this, if

=VLOOKUP(A1,B2:C30,2,0)

returns a value from C2:C30

then

=INDEX(C2:C30,MATCH(A1,B2:B30,0))

will return the same value

now index can be used within the cell function

=CELL("address",INDEX(C2:C30,MATCH(A1,B2:B30,0)))

will return the cell address, why you want to do this is beyond me though


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Dan" wrote in message
...
Want to determine the address of a given data point. The information is in
one excel sheet "data sheet" and the equation will be in another sheet
"calc
sheet". I used VLOOKUP to locate the data in the "data sheet" based on the
criteria in "calc sheet".

Now I need to determine the address of the returned data, which will be
used
for further calculations.

Thanks

Dan