In column C you would put something like

=IF(OR(AND(B2="HS",C2="NS"),AND(B2="S",C2="LS"))," Yes","No")

In other words, if B2 contains HS and C2 contains NS, or if B2
contains S and C2 contains LS, put "Yes" in the cell, otherwise put
"No".

Does that help?
--JP



On Apr 4, 11:09*am, HJ wrote:
Here is a sample of the spreadsheet I'm working with:

Column A * * * * * * * Column B * * * * * * Column C
S * * * * * * * * * * * * * *LS * * * * * * * * * * * *Yes
S * * * * * * * * * * * * * *HS * * * * * * * * * * * *No
HS * * * * * * * * * * * * *NS * * * * * * * * * * * *Yes
HS * * * * * * * * * * * * *HS * * * * * * * * * * * *No

I'm trying to determine a formula I can use to automatically populate Column
C with a yes or no based on the letters in columns a or b. *This is just a
small sample of the letters that could be used so there are multiple
combinations (NA, NS, LS, S, HS are the letters). *I was thinking I could
just use numbers instead of letters and do an if statement but letters are
preferred. *

What is the best way to approach this?

Thanks in advance for your help.