Searching on 2 columns and putting result in third column.

[RobFJ]

Columns B and C just contain either Yes, No.

Depending on the combination I want to put the text result in column C as
follows.


A B C

Yes Yes "Result 1"
Yes No "Result 2"
No Yes "Result 3"
No No "Result 4"


Can SKS help out as my formulae seem to be going more and more complex with
no correct result in sight

Tx

 

[Eduardo]

Hi Rob,
copy the table given below in sheet2 of your workbook and I assume that you
are working in sheet1 starting in row 3 so in C3 enter the formula as follow

=sumproduct(--(a3=sheet2!$a$1:$a$5),--(b3=sheet2!$b$1:$b$5),sheet2!c$1:$c$5)

 

[Luke M]

Assuming choices are in A2 and B2 respectively.

=IF(A2="Yes",IF(B2="Yes","Result 1","Result2"),IF(B2="Yes","Result
3","Result 4"))