D
Dave F
I have a bunch of formulas that use OFFSET, such as:
=OFFSET(INDEX('[Copy of MAPPING TABLE.xls]MAPPING_ACCOUNTS'!$E$1:$E
$1050,MATCH(B2,'[Copy of MAPPING TABLE.xls]MAPPING_ACCOUNTS'!$E$1:$E
$1050,0)),,-2)
As you can see, this references an external workbook. When the
external workbook is not open, this generates #VALUE! errors. I
understand that some functions do not work when they reference a
closed, external workbook.
I don't want to put the table in the workbook because of its size. Is
there a way I can modify the above formula to avoid using the OFFSET
function (which I am assuming causes the #VALUE! error)?
Thanks.
=OFFSET(INDEX('[Copy of MAPPING TABLE.xls]MAPPING_ACCOUNTS'!$E$1:$E
$1050,MATCH(B2,'[Copy of MAPPING TABLE.xls]MAPPING_ACCOUNTS'!$E$1:$E
$1050,0)),,-2)
As you can see, this references an external workbook. When the
external workbook is not open, this generates #VALUE! errors. I
understand that some functions do not work when they reference a
closed, external workbook.
I don't want to put the table in the workbook because of its size. Is
there a way I can modify the above formula to avoid using the OFFSET
function (which I am assuming causes the #VALUE! error)?
Thanks.