I want to locate the cell that a lookup function (VLOOKUP, HLOOKUP, or INDEX) gets its value from.
For example:
if Cell A2 = "lookup_ref"
then VLOOKUP("lookup_ref",A1:D4,3,False) should return the value of cell C2.
I need to be able to find out what the source cell (i.e. C2 in this...