VLOOKUP() Question... i hope
 

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

VLOOKUP() Question... i hope
 

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 @hotmail.com" <adam_kroger<nospam wrote in message
...
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

VLOOKUP() Question... i hope
 

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

Looks about the same: However

<A13 <B12 <C11
<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




"Biff" wrote in message
...
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 @hotmail.com" <adam_kroger<nospam wrote in message
...
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