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:

M	F
Push Ups	Score	Push Ups	Score
36	52	36	90
35	50	35	88
34	49	34	86
33	48	33	84
32	46	32	83
31	45	31	81
30	43	30	79
29	42	29	77

<colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody>
</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

<tbody>
</tbody>

A	B	C
M	36	using the data above should calculate and show "52"
F	30	using the data above should calculate and show "79"

<tbody>
</tbody>

 

[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