Match function
 

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

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

Match function
 

I don't understand what this means...

paste their entry into column B



"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

Match function
 

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

"JLatham" wrote:

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