![]() |
Lookup a value and return its cell reference instead of the value
I am trying to do a lookup and return the cell reference rather than the
value. I want to use this reference in an offset formula. How do I do this? |
Lookup a value and return its cell reference instead of the value
Use MATCH rather than lookup (if you used all four arguments of the lookup
function, delete the last one). "LBenslay" wrote: I am trying to do a lookup and return the cell reference rather than the value. I want to use this reference in an offset formula. How do I do this? |
All times are GMT +1. The time now is 03:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com