Comparing 2 columns

[jaymonji]

Hi guys! I have an issue i just cannot figure out. I want to check column A for the number 1 and then when a 1 is found , check the corresponding row in column B and detect if it is a "Y" or an "N". I then want to return a FALSE if there is an "N" in the corresponding row to any occurence of the number 1. If there is no "N" in any corresponding row to any 1's then i want to return a TRUE.

Is this even possible? Thank you in advance for all your help.

[xladept]

I put the result in column C:

Please Login or Register  to view this content.

[Tony Valko]

Maybe this...

Assuming your data starts on row 2...

Enter this formula in C2 and copy down as needed:

=IF(A2=1,IF(B2="N",FALSE,TRUE),"")

You didn't say what result you want if cells in column A do not =1 so I wrote the formula to return a blank in that case. I'm also assuming that column B will only contain either Y or N, nothing else and no empty cells.

[jaymonji]

I put the result in column C:

Please Login or Register  to view this content.

This is working beautifully! thank you!
I wish to expand on this however and im stumped. I want the macro to check column C and if there is any "FALSE" return "RED" to cell F1.
I tried the following -
Sub TF(): Dim A As Range
For Each A In Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row)
If A = 1 Then
If UCase(A.Offset(0, 1)) = "N" Then
A.Offset(0, 2) = "False"
Else: A.Offset(0, 2) = "True"
End If: End If: Next: End Sub
Sub TG(): Dim A As Range
For Each A In Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row)
If A = 1 Then
If UCase(A.Offset(0, 2)) = "FALSE" Then
F1 = "RED"
Else: F2 = "GREEN"
End If: End If: Next: End Sub

For some reason this does not return anything to F1 Any suggestions?

[xladept]

Try:

Please Login or Register  to view this content.

But - I don't know why you want that - do you want them in the same row instead??