Football: If statement search range and return specific value

[COVEY777]

Hello,

I am building a spreadsheet for a football pool.

I have a range of cells with the game winners and a cell with the person pick and point value.

In one cell the formula should search the range of game winners and see if it equals the pick and assign the point value if true.

The points column will display 16 if the pick is within the range of winners and 0 if not

Thanks!

		16
WINNER	NAME	PICK	POINTS
SEAHAWKS	KEVIN	SEAHAWKS	16
FALCONS	DAVID	RAMS	16
RAMS	TAYLOR	JETS	16
STEELERS	MATT	BEARS	0
EAGLES
JETS

<tbody>
</tbody>

 

[WarPigl3t]

	A	B	C	D
1	WINNER	NAME	PICK	POINTS
2	SEAHAWKS	KEVIN	SEAHAWKS	16
3	FALCONS	DAVID	RAMS	16
4	RAMS	TAYLOR	JETS	16
5	STEELERS	MATT	BEARS	0
6	EAGLES
7	JETS

<tbody>
</tbody>

Enter this formula into cell D2.

=IF(IFERROR(VLOOKUP(C2,$A$2:$A$7,1,FALSE),0)=C2,16,0)