| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
