i am trying to put together a football pool sheet. I have 3 sheets so far.
Sheet 1 is called (Results 1,2) Sheet 2 is (Week 1) and Sheet 3 is (Week 2).
I want if c4 week 1 is = to week 1 c3, then I want c3 of my Results 1,2 sheet
to return a number 1 in cell c3. Thanks Karl