Match function

A

Andy920

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
 
J

JLatham

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

Andy920

That did it, sheesh I was looking in help for Match and was showing examples
using yen lol Thank you very much JLatham Very much appreciated and just
saved me easily at least an hour a week lol Thanks again

Andy
 
Top