Forum Discussion
Need assistance / help determining formula / IF function?
Hello everyone!
I'm wholly unfamiliar with the possibilities Excel can provide, so I need help automating an effect I'd like to happen. For my life, I cannot find a similar situation online so I am reaching out to the community.
I have two 'list columns' A and B with text values you can select from, keep in mind I can NOT use numbers to formulate the response I'd like to achieve in column C. It would be a lot easier to do this if I COULD use numbers, but I cannot.
So what I am trying to achieve is something similar to the IF function. IF column A states "Almost Certain" and Column B states "Minor", C must show the result as "Low". Is this even possible?
I've added a screenshot of the values, column A would have the values on the far left, column B would have the values at the far bottom and the cross-reference is what C should show if it is possible to automate it.
I hope I've managed to explain the situation well enough, if not I'll try my best next time XD
Cheers
4 Replies
=INDEX($B$2:$F$6,MATCH(A10,$A$2:$A$6,0),MATCH(B10,$B$7:$F$7,0))An alternative could be this formula with the layout of the attached file.
That's exactly as you say
IF column A states "Almost Certain" and Column B states "Minor", C must show the result as "Low" in C2: =IF( AND( A2="Almost Certain", B2="Minor" ), "Low", "here are other variants")You may use nested IF() or IFS() for entire set of variants, even better to generate helper table for them and lookup from it.
- Thank you for this, it has become clearer as to what went wrong on my end!
What would the formula look like if you have multiple values?
For example Almost Certain + Minor = low ( and Almost Certain + Moderate = Medium etc..), Likely + Minor = low ( or Likely + Moderate = Medium etc..) etc?
CheersDepends on what "etc" means. You may put the logic into the matrix and pickup values from it; or hardcode in formula, e.g. with nested IF(). But in any case full logic is to be defined.
