Look up with 2 criteria

Hi guys,

I've the impression this is a recurrent topic, but I haven't been able to find a working solution on the internet after several hours of investigation .

I am trying to retrieve the data from one column, based on the values of two other columns (criteria). We can assume there are no repetitions. I am trying to achieve this with a combination of INDEX + MATCH and Worksheetfunction or Evaluate, because:

- other potential solutions include loops, and this may take lot of time in my Excel, which contains several thousands of rows
- I am looking for the simplest solution, and using Excel formulas looks simpler that several nested loops

I have managed to make the code work, but when I try to replace the specific addresses e.g. Source!B3:B9 with variables e.g. Rng_Country is when the code does not work, and (I think) I need to use variables because I want to apply this logic to several columns and thousands of lines.

Could any of you shed some light about the correct way here?

Many thanks