Cell Reference
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? |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com