ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lookup a value and return its cell reference instead of the value (https://www.excelbanter.com/excel-discussion-misc-queries/100129-lookup-value-return-its-cell-reference-instead-value.html)

LBenslay

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?

bpeltzer

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