IF Then Formula

[Northrun]

I am trying to score a “pick the winner” football league and need some excel formula help.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I want to type the winning team’s names in a column A1 to A10 (example: Packers, Vikings, Bears, etc.). Then I want to generate an IF/THEN formula in cell C1 to say, “If any cells in the range B1 to B25 contain the same names (Packers or Vikings or Bears) as listed in the winners column THEN the formulas will produce a value of 10 in cell C1”. Any help would be greatly appreciated.

 

[Domski]

Maybe: =IF(ISNUMBER(MATCH(B1,$A$1:$A$10,0)),10,0)

Dom

 

[Northrun]

Hey thanks, that works too! I ended up using =IF(COUNTIF($B$1:B$25,A1:A10)>0,10,"")