Thread: 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.

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.
>
>