Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y

I think you are looking for this...

=IF(B1,IF(D1=D2,"Match",""),"")

Put it in C1 and copy down.

--
Rick (MVP - Excel)


"< AVG Joe" wrote in message
...
Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y

Assuming you're putting this in conditional format, where you want the effect
applied if TRUE and a match:
=IF(B1=TRUE,IF(D2=D3,TRUE,FALSE),FALSE)

Then copy and paste special the formating.
If your using a cell and literally want the word "match" jsut change to:
=IF(B1=TRUE,IF(D2=D3,"MATCH",""),"")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"< AVG Joe" wrote:

Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y

.... or =IF(AND(B1,D1=D2),"Match","")
--
David Biddulph

"Rick Rothstein" wrote in message
...
I think you are looking for this...

=IF(B1,IF(D1=D2,"Match",""),"")

Put it in C1 and copy down.

--
Rick (MVP - Excel)


"< AVG Joe" wrote in message
...
Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y

Actually, I wasn't sure which way to go with it.
Still not - both work
THanks!

"Luke M" wrote:

Assuming you're putting this in conditional format, where you want the effect
applied if TRUE and a match:
=IF(B1=TRUE,IF(D2=D3,TRUE,FALSE),FALSE)

Then copy and paste special the formating.
If your using a cell and literally want the word "match" jsut change to:
=IF(B1=TRUE,IF(D2=D3,"MATCH",""),"")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"< AVG Joe" wrote:

Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y

Thanks!
Still unable to decide which way to go...

"Rick Rothstein" wrote:

I think you are looking for this...

=IF(B1,IF(D1=D2,"Match",""),"")

Put it in C1 and copy down.

--
Rick (MVP - Excel)


"< AVG Joe" wrote in message
...
Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y

Good point!

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
... or =IF(AND(B1,D1=D2),"Match","")
--
David Biddulph

"Rick Rothstein" wrote in message
...
I think you are looking for this...

=IF(B1,IF(D1=D2,"Match",""),"")

Put it in C1 and copy down.

--
Rick (MVP - Excel)


"< AVG Joe" wrote in message
...
Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y

Hi,

1. Using conditonal formatting means that you can look for visual effects
such as cell color, which are often easier to spot in large data sets than
cell which might say Match or No Match, for example.
2. Using condtional formatting means that you do not have to dedicate a
column of cells to holding a formula. Therefore you are conserving
spreadsheet space and reducing clutter.
3. Using the formula in the cell has the advantage that other cells can use
that result to make additional calculations, whereas formulas can't detect
condtional formatting.

I like the conditional formatting approach, except when you are using 2003
and earlier and want more than 3 conditions, which is not the case here.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"< AVG Joe" wrote:

Thanks!
Still unable to decide which way to go...

"Rick Rothstein" wrote:

I think you are looking for this...

=IF(B1,IF(D1=D2,"Match",""),"")

Put it in C1 and copy down.

--
Rick (MVP - Excel)


"< AVG Joe" wrote in message
...
Perplexed-
How do I check a condtion say If(Bw=TRUE),
Then compare cells D2 & D3 for equality)
and repeat for about 1000 rows?
Example:
A B C
D E
1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q
2 N FALSE If (B2=True, If(D2=D3),"") Q
3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y
4 Y FALSE If (B4=True, If(D4=D5), "") Y