Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching on 2 columns and putting result in third column.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching on 2 columns and putting result in third column.
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) "RobFJ" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching on 2 columns and putting result in third column.
Assuming choices are in A2 and B2 respectively.
=IF(A2="Yes",IF(B2="Yes","Result 1","Result2"),IF(B2="Yes","Result 3","Result 4")) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RobFJ" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need some help pulling columns from one table and putting into ano | Excel Discussion (Misc queries) | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
Lookup 3 columns and return a result from another column | Excel Discussion (Misc queries) | |||
insert columns macro is putting 2 columns instead of 1 | Excel Worksheet Functions | |||
Putting many columns into one | Excel Discussion (Misc queries) |