• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel syntax question

DaveB

Nice But Dim
Joined
Oct 29, 2005
Messages
21,124
Likes received
5,496
Thanks received
1,575
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?
 

Advertisers

Back
Top