G
Guest
I want to store a non-worksheet specific formula using cell references in a
lookup table in Excel, so that when the value is looked up, it calculates a
value using the selected formula using the cell references for the sheet that
the lookup command is executed.
Example:
Worksheet 1 looks up a worksheet containing formulas for the formula labled
Form1, which is A1 + B2. I want Excel to then use that formula with the
values from the cells A1 and B2 on Worksheet 1. This way, I can have
Worksheet 2 look up the same formula and have it use that formula with the
values of A1 and B2 on Worksheet 2.
The formula worksheet lookup will have multiple formulas (and other data)
repeated across many worksheets, and the worksheets themselves will have to
look up multiple lookup sheets with different sets of formulae (and other
data). As such, I need automation rather than simply copying and pasting
multiple worksheets or lookup tables.
lookup table in Excel, so that when the value is looked up, it calculates a
value using the selected formula using the cell references for the sheet that
the lookup command is executed.
Example:
Worksheet 1 looks up a worksheet containing formulas for the formula labled
Form1, which is A1 + B2. I want Excel to then use that formula with the
values from the cells A1 and B2 on Worksheet 1. This way, I can have
Worksheet 2 look up the same formula and have it use that formula with the
values of A1 and B2 on Worksheet 2.
The formula worksheet lookup will have multiple formulas (and other data)
repeated across many worksheets, and the worksheets themselves will have to
look up multiple lookup sheets with different sets of formulae (and other
data). As such, I need automation rather than simply copying and pasting
multiple worksheets or lookup tables.