VLOOKUP() Question... i hope

[Adam Kroger]

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

 

[Biff]

Hi!

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?

Well, I'm going to suggest the obvious but I have a feeling it's much more
complicated than your explanation makes it seem.

=A1

Biff

 

[Adam Kroger]

not as I understand it, a simple =B1 returns the result of whatever is in
B1 i.e.
<B1>3*2 -> 6 appears in the cell
<A1>=B1 -> 6

Looks about the same: However

<A1>3 <B1>2 <C1>1
<A2>=OFFSET(A2,-1,0)*OFFSET(A2,-1,1) returns 6
<B2)=A2 still returns 6 not 2*1=2

I need something like an EVALUATE() command, that would pull the text string
or formula/function from another cell and act on it as if it was written
inside the calling cell. That was the formula A1*A2 that was written inside
a cell on Sheet_2 could be called by a Cell on Sheet_1 and the formula would
evaluate sheet_1!A1*sheet_1!A2 instead of
sheet!2A1*sheet_2!A2