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!
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="align: center"]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WINNER[/TD]
[TD]NAME[/TD]
[TD]PICK[/TD]
[TD]POINTS[/TD]
[/TR]
[TR]
[TD]SEAHAWKS[/TD]
[TD]KEVIN[/TD]
[TD]SEAHAWKS[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]FALCONS[/TD]
[TD]DAVID[/TD]
[TD]RAMS[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]RAMS[/TD]
[TD]TAYLOR[/TD]
[TD]JETS[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]STEELERS[/TD]
[TD]MATT[/TD]
[TD]BEARS[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]EAGLES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JETS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[WarPigl3t]

[TABLE="class: grid, width: 275"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]WINNER
[/TD]
[TD="align: center"]NAME[/TD]
[TD="align: center"]PICK[/TD]
[TD="align: center"]POINTS[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD]SEAHAWKS[/TD]
[TD]KEVIN[/TD]
[TD]SEAHAWKS
[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD]FALCONS[/TD]
[TD]DAVID[/TD]
[TD]RAMS[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD]RAMS[/TD]
[TD]TAYLOR[/TD]
[TD]JETS[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD]STEELERS[/TD]
[TD]MATT[/TD]
[TD]BEARS[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD]EAGLES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD]JETS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Enter this formula into cell D2.

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