return the Cell address of a value
 

Column C Column D
Age 3
Column A Column B


1 0.001 I would like to look up the value column A that matches
2 0.002 the value in Column D (3) and display the result as the cell
3 0.003 address
4 0.004 I'm using Excel 2007

return the Cell address of a value
 

Try this...

Assuming the data in column A is in the range A3:A100.

=ADDRESS(MATCH(D2,A3:A100,0)+ROW(A3)-1,COLUMN(A3),4)

--
Biff
Microsoft Excel MVP


"Jack_442" wrote in message
...
Column C Column D
Age 3
Column A Column B


1 0.001 I would like to look up the value column A that matches
2 0.002 the value in Column D (3) and display the result as the cell
3 0.003 address
4 0.004 I'm using Excel 2007

return the Cell address of a value
 

Thank you this works

"T. Valko" wrote:

Try this...

Assuming the data in column A is in the range A3:A100.

=ADDRESS(MATCH(D2,A3:A100,0)+ROW(A3)-1,COLUMN(A3),4)

--
Biff
Microsoft Excel MVP


"Jack_442" wrote in message
...
Column C Column D
Age 3
Column A Column B


1 0.001 I would like to look up the value column A that matches
2 0.002 the value in Column D (3) and display the result as the cell
3 0.003 address
4 0.004 I'm using Excel 2007

return the Cell address of a value
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jack_442" wrote in message
...
Thank you this works

"T. Valko" wrote:

Try this...

Assuming the data in column A is in the range A3:A100.

=ADDRESS(MATCH(D2,A3:A100,0)+ROW(A3)-1,COLUMN(A3),4)

--
Biff
Microsoft Excel MVP


"Jack_442" wrote in message
...
Column C Column D
Age 3
Column A Column B


1 0.001 I would like to look up the value column A that matches
2 0.002 the value in Column D (3) and display the result as the cell
3 0.003 address
4 0.004 I'm using Excel 2007