Vlookup - Country conditions (Multiple conditions)

Hello Excel Experts,

I have a situation with vlookup and hopefully you could help.

Situation:

In the attached file, I have 3 sheets - 'Vlookup-Data', 'Table' and 'ProductRate' where Vlookup-Data is where the result of vlookup will be, Table is where the Code is eligible for countries specified, ProductRate is where the rate of each product is.

Thus, I need to do a vlookup getting the rate of 'sms' or 'voice' after it has done the initial check.

Example1: Row4 of 'Vlookup-Data'. It is a 'T-Code..1' located at 'France'. Since 'T-Code..1' is a 'YES' on 'Table' Sheet, get the value of SMS in 'ProductRate'

Example2: Row11 of 'Vlookup-Data'. It is a 'T-Code..2' located at 'India'. Since 'T-Code..2' is a BLANK on 'Table' Sheet, IGNORE any lookup.

Hopefully I'm able to clearly explain. If not, I believe the attached file would be able to clearly show you what I want to accomplish.

Thank you for your help and input!

Thanks Benishiryo!!!

It works! Now, let me try to put that code together with my actual data that has other formula in it.

Reps up for you! Please check!

Hi Benishiryo,

I tried to modified the code a little, where in the real data, there's countries that are not listed in the 'Table' but were on the 'Vlookup-Data'.

I tried to put ISERROR function on the code, but it's still giving me #N/A.

Would you be able to help me out.

Please Login or Register  to view this content.

Genius!!!

Now I believe it's solved!

I tried using the ISERROR function...when I separate them, it works, but when I combined, it doesn't...

Anyway, thanks for your help Benishiryo!