Newb****“IF” and “match” with text to generate a number value.

[en95076]

I ran a search within the forums and didn’t find anything that would help me. If this is double post my apologies.

I’m been designated as the Office football pool guy. I have been doing ok but I ran into a problem.

I’m trying to make someone’s pick match a list of winners. If a pick matches any of the name on the results column it needs to generate a point from 13-1 depending on how many games in the week.
13 being your most confident pick and 1 being your least confident pick.

This is my current formula =IF(MATCH(C2,$A$2:$A$14,0),13,0) How do I make the picks someone missed calculate to 0 and not “N/A”

Thanks beforehand… Also once I solve this and anyone needs it to run their football pool. Email me, I’ll be happy to share it.

[TABLE="width: 464"]
<tbody>[TR]
[TD][TABLE="width: 464"]
<tbody>[TR]
[TD]Results[/TD]
[TD]Points[/TD]
[TD="colspan: 2"]John[/TD]
[/TR]
[TR]
[TD]Carolina[/TD]
[TD]13[/TD]
[TD]San Francisco[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]San Francisco[/TD]
[TD]12[/TD]
[TD]Denver[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Kansas City[/TD]
[TD]11[/TD]
[TD]New England[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]New Orleans[/TD]
[TD]10[/TD]
[TD]Green Bay[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]New England[/TD]
[TD]9[/TD]
[TD]Seattle[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Denver[/TD]
[TD]8[/TD]
[TD]Kansas City[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Oakland[/TD]
[TD]7[/TD]
[TD]New Orleans[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Cincinnati[/TD]
[TD]6[/TD]
[TD]Dallas[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]Detroit[/TD]
[TD]5[/TD]
[TD]Atlanta[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]NY Giants[/TD]
[TD]4[/TD]
[TD]Cincinnati[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Arizona[/TD]
[TD]3[/TD]
[TD]Pittsburgh[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]Green Bay[/TD]
[TD]2[/TD]
[TD]Philadelphia[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]Seattle[/TD]
[TD]1[/TD]
[TD]Carolina[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[/TR]
</tbody>[/TABLE]

 

[fibonacci1101]

if you're using excel 2007 or higher you can use IFERROR function:

=IFERROR(IF(MATCH(C2,$A$2:$A$14,0),13,0),0)

 

[en95076]

fibonacci1101 you are a genius! Thanks a lot it worked perfect!