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.

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.