If VLOOKUP(MATCH()) retruns an equation/function is there a way for it (the
function) to retrun a vaule that is based its new relative position calling,
on data that is contained within the sheet to wich it was called in the
VLOOKUP(MATCH())? The VLOOKUP(MATCH()) would be used on multiple sheets

corralary:
If a cell, say A1 has a formula in it, is there a function that you could
use in A5 that would call that function and have it operate as if it had
been copied to the cell?

I have a suspiscion that the answer is going to be VBA, but I am hoping for
a function.

Thanks
Adam