Thread: Match function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Match function

Team in A1, selected team in B1
in C1
=IF(A1=B1,1,0)
??
Is that what you're looking for?

"Andy920" wrote:

I run football pool and am trying to find out how to make my life easier lol
I am looking for the formula I would need where I would put the winning teams
in column A, paste their entry into column B and have column C show a value
of 1 if it matched. Would appreciate any help Thanks in advance

Andy