Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup vba question. | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
Vlookup question | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |