cell reference and formula
 

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

cell reference and formula
 

In cell C3 on your Results sheet, enter this formula:

=IF('Week 1'!C4='Week 1'!C3,1,0)

Since you didn't specify what you wanted if C4 didn't equal C3, I just put
0, but you can change that to whatever you need.

HTH,
Elkar


"Karl" wrote:

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

cell reference and formula
 

Thanks that worked great. How do i copy it to other cells so it keeps cell c3
as my target cell with the info in it. As I copy it changes and adds a cell
but i always want cell c3 to be the info cell to reference to. Thanks Karl

"Elkar" wrote:

In cell C3 on your Results sheet, enter this formula:

=IF('Week 1'!C4='Week 1'!C3,1,0)

Since you didn't specify what you wanted if C4 didn't equal C3, I just put
0, but you can change that to whatever you need.

HTH,
Elkar


"Karl" wrote:

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

cell reference and formula
 

Use an Absolute Reference. $C$3 instead of C3. The $ symbol will prevent
Excel from incrementing the reference when copied.

HTH,
Elkar


"Karl" wrote:

Thanks that worked great. How do i copy it to other cells so it keeps cell c3
as my target cell with the info in it. As I copy it changes and adds a cell
but i always want cell c3 to be the info cell to reference to. Thanks Karl

"Elkar" wrote:

In cell C3 on your Results sheet, enter this formula:

=IF('Week 1'!C4='Week 1'!C3,1,0)

Since you didn't specify what you wanted if C4 didn't equal C3, I just put
0, but you can change that to whatever you need.

HTH,
Elkar


"Karl" wrote:

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

cell reference and formula
 

Thank you very much worked very good. Karl

"Elkar" wrote:

Use an Absolute Reference. $C$3 instead of C3. The $ symbol will prevent
Excel from incrementing the reference when copied.

HTH,
Elkar


"Karl" wrote:

Thanks that worked great. How do i copy it to other cells so it keeps cell c3
as my target cell with the info in it. As I copy it changes and adds a cell
but i always want cell c3 to be the info cell to reference to. Thanks Karl

"Elkar" wrote:

In cell C3 on your Results sheet, enter this formula:

=IF('Week 1'!C4='Week 1'!C3,1,0)

Since you didn't specify what you wanted if C4 didn't equal C3, I just put
0, but you can change that to whatever you need.

HTH,
Elkar


"Karl" wrote:

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