Hi - has anyone successfully returned a cell's reference rather than its contents?
I have the following formula:
=VLOOKUP(A3,Sheet2!$A$1:$I$450,9,FALSE)
This returns the value: 23
I would like a formula that returns the sheet and Cell Reference that this resides within. In this instance, the sheet is Sheet2 and the cell is I9
I have attempted to nest my VLOOKUP within a CELL function but Excel doesn't like this.
Thanks for your help!
Warren
Bookmarks