| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get values in a column based on values in two other columns
Hello,
I have a situation, wherein, Column-A and Column-B can have one of the three values: Low, Medium, High. I would like Column C to be filled up with a value based on the combination of values in column A and B. For example: column A Column B Column C low low 2 low medium 10 Use of =IF(AND(A1='Low',B1='low'),2,1000) works for only one such combination. I would like all such cases to be "ORed". Any help would be great...!! Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get values in a column based on values in two other columns
something like this (for row 3) add as many combinations as you like
=AND(A3="low",B3="low")*2+AND(A3="low",B3="medium" )*10 "ssb" wrote: Hello, I have a situation, wherein, Column-A and Column-B can have one of the three values: Low, Medium, High. I would like Column C to be filled up with a value based on the combination of values in column A and B. For example: column A Column B Column C low low 2 low medium 10 Use of =IF(AND(A1='Low',B1='low'),2,1000) works for only one such combination. I would like all such cases to be "ORed". Any help would be great...!! Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| How can SUM a column based on values of other columns? | New Users to Excel | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Add up a column based on values in other columns | Excel Worksheet Functions | |||
| looking up values in 1 column based on 2 other columns | Excel Worksheet Functions | |||
Linear Mode
