I'm having a problem with this formula, #Invalid Operation referencing another sheet.

Veronica Machon

=IF(CampaignCode1 = {Oracle ANZ Marketing Calendar CampaignCode}, {Oracle ANZ Marketing Calendar Pillar})

I'm wanting to look at the master sheet, match the campaign code and display the Pillar, can someone please help?

Paul Newcome

Try something along the lines of...

=INDEX({Oracle ANZ Marketing Calendar Pillar}, MATCH(CampaignCode1, {Oracle ANZ Marketing Calendar CampaignCode}, 0))