I have a work sheet that uses a formula in multiple places to refer to another sheet in the same work book to fetch data from the second sheet. That sheet I'm working on needs to be added to other workbooks to perform the same function but with differently named worksheets as the data source.
I cannot for the life of me figure out the syntax to be able to put the target worksheet name in a cell and refer to that in the formula without breaking it. Formula is
=IF(A15="","",(INDEX(C26,MATCH(A15,'DATA SOURCE'!$F$4:$F$100,0),9)))
I've tried INDIRECT etc but just can't get the syntax right.
DATA SOURCE is the bit I need to make generic so the only change needed to add the sheet to other workbooks is to change one cell rather than a dozen formulas.
Any suggestions?
I cannot for the life of me figure out the syntax to be able to put the target worksheet name in a cell and refer to that in the formula without breaking it. Formula is
=IF(A15="","",(INDEX(C26,MATCH(A15,'DATA SOURCE'!$F$4:$F$100,0),9)))
I've tried INDIRECT etc but just can't get the syntax right.
DATA SOURCE is the bit I need to make generic so the only change needed to add the sheet to other workbooks is to change one cell rather than a dozen formulas.
Any suggestions?
Comment