return the Cell address of a value

  • Thread starter Thread starter Jack_442
  • Start date Start date
J

Jack_442

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
 
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)
 
Back
Top