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

G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return cell reference instead of value 1
Return value greater than in LOOKUP 3
How to reference a null value? ie: =Lookup("", B2:B4, A2:A4) 6
Offset with hlookup as reference 2
Vlookup with value between 2 cells and return greater value. 6
return a formula instead of a value of a cell 4
Help needed 0
Look up a reference which has more than 1 exact match 1

Top