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

Use match with index instead

--
Don Guillett
SalesAid Software

"Rachel" wrote in message
...
When looking up a value in a range, how do I return the cell reference
instead of the value?

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,Ran ge,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)

--

Regards,

Peo Sjoblom

"Don Guillett" wrote in message
...
Use match with index instead

--
Don Guillett
SalesAid Software

"Rachel" wrote in message
...
When looking up a value in a range, how do I return the cell reference
instead of the value?