VBA - Lookup with multiple conditions/criteria

Its difficult to understand what you really want without seeing your files, anyway, I tried to do something and you may change the code to suit your needs.

I am posting wb1.xlsm, and in this file I also created a table. In the country column you will find a formula that is looking for the country in wb2 using INDEX and MATCH functions. In this way you don't need any VBA. If the wb2 is not opened then the countries will be blank.