I have a spreadsheet with 2 worksheets. One named Test Data and the other named TFR
The following formula works perfectly in the Test Data worksheet but has a #value error when the same formula is used in the TFR worksheet
When I run Evaluate Formulas in the TFR worksheet the #value error occurs at this point
I have spent hours trying to work this out so if someone could help, I would be very grateful.
Thanks
The following formula works perfectly in the Test Data worksheet but has a #value error when the same formula is used in the TFR worksheet
Excel Formula:
=CELL("address";(OFFSET(INDEX('Test Data'!$A$8:(INDIRECT('Test Data'!W4));MATCH(TFR!D3;'Test Data'!$A$8:(INDIRECT('Test Data'!W4)))+1;);0;3)))
When I run Evaluate Formulas in the TFR worksheet the #value error occurs at this point
Excel Formula:
('Test Data'!$A$8:(INDIRECT('Test Data'!W4))
I have spent hours trying to work this out so if someone could help, I would be very grateful.
Thanks
Last edited by a moderator: