Forum Discussion
Vlookup based off multiple conditions
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.
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.