Thanks. I ended up adding a table assigning the letters to numbers and did a
vlookup. There were just too many combinations for the IF statement.

"JP" wrote:

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.