Nested IF statements or CHOOSE statements needed for multiple conditions formula

I have the text in two column - example column R has "High" and column s has "annual".

I have a set of conditions that I need the formula to perform:

if Column R has "high" and column S has "annual", the formula should display the words "1" in column U.

if Column R has "medium" and column S has "annual", the formula should display the words "1" in column U.

if Column R has "low" and column S has "monthly", the formula should display the words "1" in column U.

if Column R has "high" and column S has "quarterly", the formula should display the words "3" in column U.

if Column R has "medium" and column S has "quarterly", the formula should display the words "2" in column U.

if Column R has "low" and column S has "quarterly", the formula should display the words "1" in column U.


Can someone please help in the next few minutes if possible, I'd appreciate it!

Thanks!!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thank you for revising your title salmansaif - good titles aid searches.

Welcome to the Board.

U can use the long way by IF functionusing formula

=IF(OR(AND(R1="high",S1="annual"),AND(R1="medium",S1="annual"),AND(R1="low",S1="quarterly"),AND(R1="low",S1="monthly")),1,IF(AND(R1="high",S1="quarterly"),3,2))

Or create a small table near and use SUMPRODUCT

=SUMPRODUCT((R1=N2:N7)*(S1=O2:O7)*(P2:P7))


In short see attached file

Thanks for all your help but for some reason, the formula as I put it is not erroring out, but still giving the wrong answer.

I am attaching the spreadsheet - the formula needs to be in column "U" based on the blue "key" columns.

So for example, if R7 is medium and S7 is monthly, based on the key, the formula should generate "3" in column U.

Please feel free to edit the spreadsheet and attach back to your response. Again, thanks for your fast response!

I think u should provide us with all conditions...

In any case I've done some changes by adding new sheet, which u can hide in the future.

See book pls..

well they wouldnt medium/monthly is not in your original list of requirements
but the table with
=SUMPRODUCT((R1=N2:N7)*(S1=O2:O7)*(P2:P7))
idea is worth persuing then you can have them all

Chance2 created better table than me.

I used this table in source sheet. It'll easy for editing
Formula is:

=IF(ISERROR(OFFSET('Source sheet'!$A$1,MATCH(KY!R7,'Source sheet'!$A$2:$A$4,0),MATCH(KY!S7,'Source sheet'!$B$1:$D$1,0))),"",OFFSET('Source sheet'!$A$1,MATCH(KY!R7,'Source sheet'!$A$2:$A$4,0),MATCH(KY!S7,'Source sheet'!$B$1:$D$1,0)))