Lookup a value and return its cell reference instead of the value

L

LBenslay

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?
 
B

bpeltzer

Use MATCH rather than lookup (if you used all four arguments of the lookup
function, delete the last one).
 
Top