Cell Reference

Luke · Jul 6, 2007

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

bj · Jul 6, 2007

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

Luke · Jul 8, 2007

Great, thanks BJ

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