i have 2 workbooks entitled [price] and [fruit] respectively
[price], sheet1!, cell A1 is a variable which can contains a cell address, eg $D$1
[fruit], sheet1!, contains information in cells as follows:
D1 = apples
D2 = bananas
D3 = cherries
in the [price] workbook, i want to have a formula in say, cell B1, which would use the cell reference in A1 to find the value in the [fruit] workbook.
so, if [price]sheet1!A1 = $D$1
then [price]sheet1!B1 = apples
note that the result "apples" was pulled from another workbook, [fruit]sheet1!$D$1.
if [price]sheet1!A1 = $D$2,
then B2 = bananas
and so on...
in the [price] workbook,
As A1 is a variable, i do not want to physically retype the value within A1, but rather draw reference to it inside of a formula. i hope this is clear as mud.
Is this possible?
Thanks,
markus
[price], sheet1!, cell A1 is a variable which can contains a cell address, eg $D$1
[fruit], sheet1!, contains information in cells as follows:
D1 = apples
D2 = bananas
D3 = cherries
in the [price] workbook, i want to have a formula in say, cell B1, which would use the cell reference in A1 to find the value in the [fruit] workbook.
so, if [price]sheet1!A1 = $D$1
then [price]sheet1!B1 = apples
note that the result "apples" was pulled from another workbook, [fruit]sheet1!$D$1.
if [price]sheet1!A1 = $D$2,
then B2 = bananas
and so on...
in the [price] workbook,
As A1 is a variable, i do not want to physically retype the value within A1, but rather draw reference to it inside of a formula. i hope this is clear as mud.
Is this possible?
Thanks,
markus