INDEX & MATCH - Different Sheets

**Harlequin** · 08-29-2007, 10:44 AM

Hello.

This is a simplified version of what I am looking for.

I have 2 sheets (Tier 1 & 2). The both have the same months in Column B, but different locations in each sheet from columns C-D.

I’ve done an INDEX & MATCH for the first Tier (Tier 1). How do I incorporate the sheet Tier 2 into the formula?

Regards

**NBVC** · 08-29-2007, 10:54 AM

What do you mean by incorporate into the formula?

If you don't have the country name in Tier 2, how do you incorporate that sheet?

**Harlequin** · 08-29-2007, 11:19 AM

I want to be able to bring the Locations (Asia Austrialia, & Africa) that are in sheet 2 (2nd Tier) into the the formula in "Template" cell C4.

Regards

**NBVC** · 08-29-2007, 11:31 AM

Originally Posted by Harlequin

I want to be able to bring the Locations (Asia Austrialia, & Africa) that are in sheet 2 (2nd Tier) into the the formula in "Template" cell C4.

Regards

Try:

=IF(ISNUMBER(MATCH(C3,'1st Tier'!C1:E1,0)),INDEX('1st Tier'!B1:F14,MATCH(Template!C2,'1st Tier'!B1:B14,0),MATCH(Template!C3,'1st Tier'!B1:F1,0)),INDEX('2nd Tier'!C1:E13,MATCH(Template!C2,'2nd Tier'!B1:B13,0),MATCH(Template!C3,'2nd Tier'!C1:E1,0)))