Combining If THEN and VLOOKUP

[mrsadventure]

I am in desperate need of help. I am a novice at excel formulas. I need to write a formula that will pull from a set of data the separates between a Male or Female, Number of Push Ups and then provides a score...so for example:

<colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody>
[TD="class: xl66, width: 128, colspan: 2, align: center"]M
[/TD]
[TD="class: xl66, width: 128, colspan: 2, align: center"]F
[/TD]

[TD="class: xl66, align: center"]Push Ups[/TD]
[TD="class: xl66, align: center"]Score[/TD]
[TD="class: xl66, align: center"]Push Ups[/TD]
[TD="class: xl66, align: center"]Score[/TD]

[TD="class: xl63, align: center"]36[/TD]
[TD="class: xl65, align: center"]52[/TD]
[TD="class: xl63, align: center"]36[/TD]
[TD="class: xl64, align: center"]90[/TD]

[TD="class: xl63, align: center"]35[/TD]
[TD="class: xl65, align: center"]50[/TD]
[TD="class: xl63, align: center"]35[/TD]
[TD="class: xl64, align: center"]88[/TD]

[TD="class: xl63, align: center"]34[/TD]
[TD="class: xl65, align: center"]49[/TD]
[TD="class: xl63, align: center"]34[/TD]
[TD="class: xl64, align: center"]86[/TD]

[TD="class: xl63, align: center"]33[/TD]
[TD="class: xl65, align: center"]48[/TD]
[TD="class: xl63, align: center"]33[/TD]
[TD="class: xl64, align: center"]84
[/TD]

[TD="class: xl63, align: center"]32[/TD]
[TD="class: xl65, align: center"]46[/TD]
[TD="class: xl63, align: center"]32[/TD]
[TD="class: xl64, align: center"]83[/TD]

[TD="class: xl63, align: center"]31[/TD]
[TD="class: xl65, align: center"]45[/TD]
[TD="class: xl63, align: center"]31[/TD]
[TD="class: xl64, align: center"]81[/TD]

[TD="class: xl63, align: center"]30[/TD]
[TD="class: xl65, align: center"]43[/TD]
[TD="class: xl63, align: center"]30[/TD]
[TD="class: xl64, align: center"]79[/TD]

[TD="class: xl63, align: center"]29[/TD]
[TD="class: xl65, align: center"]42[/TD]
[TD="class: xl63, align: center"]29[/TD]
[TD="class: xl64, align: center"]77
[/TD]

</tbody>

So if I am in a new spreadsheet, first column (A) would say M or F, then I will enter data in column (B) then I need Column C to show the corresponding answer, for example[TABLE="width: 500"]
<tbody>[TR]

[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]M
[/TD]
[TD]36
[/TD]
[TD]using the data above should calculate and show "52"
[/TD]
[/TR]
[TR]
[TD]F
[/TD]
[TD]30
[/TD]
[TD]using the data above should calculate and show "79"
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Hi & welcome to MrExcel
How about

Excel 2013/2016
	A	B	C
1	A	B	C
2	M	30	43
3	F	36	90
Sheet2

Cell Formulas
Range	Formula
C2	=SUMPRODUCT((Sheet1!$A$1:$D$1=A2)*(Sheet1!$A$3:$D$10=B2),Sheet1!$B$3:$E$10)

Excel 2013/2016
	A	B	C	D
1	M		F
2	Push Ups	Score	Push Ups	Score
3	36	52	36	90
4	35	50	35	88
5	34	49	34	86
6	33	48	33	84
7	32	46	32	83
8	31	45	31	81
9	30	43	30	79
10	29	42	29	77
Sheet1