Get values in a column based on values in two other columns

S

ssb

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

duane

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
 

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

Use a variable in a ShapeRange.Increment 0
Formula: Counting Cells on Different Worksheets 3
Combining Text based on Values 8
Create a list using two criteria 4
populating cells using data from a different worksheet 4
Automatic Regressions based on Field Values 0
Two columns : Continuous two columns vs Parallel two Column 1
Cobditional Formatting Rows based on dates in action plan. 0

Top