return the Cell address of a value

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
 
T

T. Valko

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)
 
J

Jack_442

Thank you this works

T. Valko said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Match value return a text 6
With F1 value, look at A, if match or partial match return B 5
match values and return a third one 6
Compare 2 lists and return value 2
Return the value in the last cell of the list 8
Excel VBA 1
Match Text return a value from the row 2

Top