The usual technique is to VLOOKUP() to determine the value and then use the
MATCH() function to return the location of the value ( if you know the row
and column this is equivalent to the address)
--
Gary's Student


"psych142" wrote:

I am trying to use the VLOOKUP command but want it to return a cell address
rather than the result, i tried ADDRESS but to no avail as i wouldn't know
its position with the worksheet