Cell Reference

[Guest]

Hi,
Is there a function or formula i can use to look up a value and then display
the cell reference ie C4?
Many thanks
Luke

 

[Guest]

if I read what you want correctly
try
=address(index(range,match(criteria,match,0)))
will give the cell address

 

[Guest]

Great, thanks BJ

if I read what you want correctly
try
=address(index(range,match(criteria,match,0)))
will give the cell address