Searching on 2 columns and putting result in third column.

  • Thread starter Thread starter RobFJ
  • Start date Start date
R

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
 
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)
 
Assuming choices are in A2 and B2 respectively.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking values in 2 columns 4
how to count#cells w/= value in other column and not count blank c 4
Counting number of rows based on mutiple criteria 2
Networkdays and misleading results from blank column 3
Copying formulas across columns 2
combining column content 8
Hide columns based on row values 2
Count, Sum, Index,Match or other formula needed 1

Back
Top