Vlookup with multiple conditions

[qontrol]

Hello guys,

I have a difficulty finding the right formula for my problem. I started my vlookup with many if's but didn't work. Choose function didn't work eather.

I have to search for the correct owner based on multiple conditions:

1. If the ProductBrandCode is AB_N00, AB1_N00 or AB2_N00 (or more) -> owner should always be Owner3 (ABSAF)
2. If the ProductBrandCode is NOT AB_N00, AB1_N00 or AB2_N00 (or more) -> owner can be Owner2 or Owner3
3. If the ProductBrandCode is GSA_N00 or SAMU_N00 (or more) -> Should always be Owner2
4. If the ProductBrandCode is not in both lists -> owner should be Owner1

You can download my sheet here:

https://ufile.io/2moq2

Hopefully you can help me.

Regards,
Qontrol

 

[Joe4]

Many of us are unable/unwilling to download files from the internet (my corporate security policy actually prohibits it from my place of work). So you may have a better chance of getting responses if you can post images directly to this thread using the tools mentioned in Section B here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Also, I see an issue with this condition here:

2. If the ProductBrandCode is NOT AB_N00, AB1_N00 or AB2_N00 (or more) -> owner can be Owner2 or Owner3

So what do you want the formula to return in this instance, Owner2 or Owner3?