Vlookup based off multiple conditions

New Contributor

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. 

2 Replies

@btruman 

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

 

Thank you so much! Spent an hr. trying to figure this out.