Cell Reference

R

Rachel

When looking up a value in a range, how do I return the cell reference
instead of the value?
 
P

Peo Sjoblom

Not really, INDEX with MATCH will return the value. You can wrap index/match
in the cell functions like

=CELL("address",INDEX(Range,MATCH(lookup_value,Range,0)))

will return the absolute address, or you can use the ADDRESS function and
MATCH

=ADDRESS(row_num,column_num)

where the row or column numbers can be replaced with match (or both)
 
Top