Problems with Index and Match formula

**aglopez08** · 02-27-2013, 03:11 PM

I have a tab named “Main” in which the user will input a Letter, a Period and a Color, I want to output a number from the others tabs depending on the input letter.

i.e. Letter:A (name of worksheet)
Period: Q1
Color: Yellow
Output:10

I been trying to use Index and Match formula but I can't seem to get the information from the different worksheets depending on the three inputs.

Any Help with this will be appreciated ,
Thank You

**oeldere** · 02-27-2013, 03:26 PM

Is it not possible for you to put all data in one (summary) sheet?

Then you can easy use index / match to find the data

**martindwilson** · 02-27-2013, 03:28 PM

make sure all your ranges are in the same place ie b2:g6
=INDEX(INDIRECT(C2&"!b2:g6"),MATCH(C3,INDIRECT(C2&"!b2:b6"),0),MATCH(C4,INDIRECT(C2&"!b2:g2"),0))