USING VLOOKUP TO RETURN A CELL ADDRESS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

psych142 - 21 Nov 2006 17:13 GMT

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

Reply to this Message

Alok - 21 Nov 2006 19:34 GMT

Say your lookup table is in A1:B7 and the lookup value is in A9 and say that
you normally lookup in column B(1 column offset from column A) then you will
use the following to get the address of the same cell.

=ADDRESS(ROW(A1:A7)+MATCH(A9,A1:A7,FALSE)-1,COLUMN(A1:A7)+1)

> 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

Reply to this Message

Gary''s Student - 21 Nov 2006 19:39 GMT

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)

Signature

Gary's Student

> 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

Reply to this Message