Index formula, Multiple Criteria, Two Different Worksheets

[abrig005]

Hello, I am trying to figure out a formula the will copy the 1's in the Export Sheet C2:F6 and place them in the Track Sheet in cells C2:F6.
The Export Sheet contains the data and the Track Sheet should match A2, B2, and C1 with the same cells in the Export Sheet to get the correct cell with the 1's in them.

 

[sheetspread]

In C2:

=VLOOKUP($B2,'Export Sheet'!$B$2:$F$6,MATCH(C$1,'Export Sheet'!$B$1:$F$1,0),0)

copy across

 

[abrig005]

Oh man, I forgot to mention that this is a super simplified version and the columns are not in this particular order and the text can vary for each pull. For example the Gym data can be in a different spot the next time I download it as can the Product and Ability text.

 

[sheetspread]

The formula can handle a different order of gym columns and ability rows, but it doesn't check the product. I'll post another formula that does.

 

[sheetspread]

=INDEX('Export Sheet'!$C$2:$F$6,MATCH('Export Sheet'!$B2,IF('Export Sheet'!$A$2:$A$6=Track!$A2,'Export Sheet'!$B$2:$B$6,0)),MATCH(Track!C$1,'Export Sheet'!$C$1:$F$1,0))

 

[abrig005]

I REALLY appreciate your help, and I REALLY apologize for not explaining my problem exactly the first time.

Your formulas work however I realized that most of my data has repeat products.
The formula can use A or B in the Export Sheet because I will concatenate and adjust the formula later.
The issue now is the Export Sheet will have several repeat rows (repeat Products) that map to different GYM data in C-F
The Track sheet just has one occurrence of the product that I have to map to the GYM columns.
Is there a way to go line by line in the Export Sheet to see which GYM has a 1 under it and then transfer that over to the unique row in the Track sheet?

Once again, thank you very much for your time and assistance.

 

[sheetspread]

Is the data just 1 or blank (or some other number) but no text? If yes, then a sumproduct will work. If text then it's a bit more complicated.

 

[abrig005]

Its just a 1 or a blank.
I tried this
=INDEX('Export Sheet'!$C$2:$F$9, MATCH(C$1, 'Export Sheet'!$C$1:$F$1,0), MATCH($B6,'Export Sheet'!$B$2:$B$9,0))
and it works for Product 1- 4 but then I get a #REF error in C6: F6 in the Track worksheet.

 

[sheetspread]

This any better?

Excel 2010
	A	B	C	D	E	F
1	Product	Ability	Gym1	Gym2	Gym3	Gym4
2	Product 1	Strength	1			1
3	Product 2	Cardio		1	1
4	Product 3	Strength and Cardio	1	1	1	1
5	Product 4	Core				1
6	Product 5	Self Defense				1
7	Product 5	Self Defense		1
8	Product 5	Self Defense			1
9	Product 5	Self Defense	1
Export Sheet

Excel 2010
	A	B	C	D	E	F
1	Product	Ability	Gym1	Gym2	Gym3	Gym4
2	Product 1	Strength	1	0	0	1
3	Product 2	Cardio	0	1	1	0
4	Product 3	Strength and Cardio	1	1	1	1
5	Product 4	Core	0	0	0	1
6	Product 5	Self Defense	1	1	1	1
Track

Cell Formulas
Range	Formula
C2	=SUMPRODUCT(('Export Sheet'!$A$2:$A$9=Track!$A2)*('Export Sheet'!$B$2:$B$9=Track!$B2)*('Export Sheet'!$C$1:$F$1=Track!C$1)*'Export Sheet'!$C$2:$F$9)

 

[abrig005]

YESSSSSSSSS!!!!!!!
Thank you very much this worked!!!!!!!!!!