Oct 15 2021 11:55 AM
I am trying to create a formula based off of multiple conditions that include essentially a category, status and an owner. The owner would be based off the previous two conditions. There are multiple options(5+) for category and status.
For Example:
Retail + In Progress = Joe
Retail + Ready to Invoice = Bob
Distribution + In Progress = Alex
Distribution + Ready to Invoice = Sam
Appreciate the help. Thanks.
Oct 15 2021 12:23 PM
SolutionI suggest to enter below formula in C2 and then copy down.
=IF(A2="Retail ",VLOOKUP(B2,$I$1:$J$3,2,FALSE),
VLOOKUP(B2,$L$1:$M$3,2,FALSE))
Please be aware that data in range A2:A3 is entered with a space " ". In A2 "Retail " is entered and in A3 "Distribution ". This is why in the IF formula A2="Retail " has to be entered in order to find an exact match.
I strongly recommend to remove spaces " " in A2:A3 (and in all cells to be added to column A) and to enter A2="Retail" (without a space) in the IF formula.
Oct 15 2021 12:33 PM
Oct 15 2021 12:23 PM
SolutionI suggest to enter below formula in C2 and then copy down.
=IF(A2="Retail ",VLOOKUP(B2,$I$1:$J$3,2,FALSE),
VLOOKUP(B2,$L$1:$M$3,2,FALSE))
Please be aware that data in range A2:A3 is entered with a space " ". In A2 "Retail " is entered and in A3 "Distribution ". This is why in the IF formula A2="Retail " has to be entered in order to find an exact match.
I strongly recommend to remove spaces " " in A2:A3 (and in all cells to be added to column A) and to enter A2="Retail" (without a space) in the IF formula.