Pull Data from one sheet to another based on 4 conditions.

Hi guys,

I am moving along in my masters project and I am having a problem organizing some data I got dumped with.

What I have is a 196 x 196 matrix of the worlds countries and the distance between each one. So each Row has a title header of a country and each column has a country and the cells between the two are the distance of said countries.

On another sheet I have about 10 000 different combinations of dates/years/months ect that I need to populate in order for Stata to work properly.

Rather than manually enter thse in one by one or copy paste what I would like to do is write a code that would do something like this.

If on sheet 2 (the combination sheet) A3 = Afghanistain and C3 = China than F3 = The China/Afghanistain intersection (In this case AN3 on the Distance Sheet)

I am having problems because I can't see to figure out a way to have a program lookup the intersection and give me the China/Afghanistan number based on all the conditions. I am assuming I need to use a matrix lookup of some sort. This way when I do some like Canada/Denmark on the Combination sheet, it will automatically look up and populate the distance from the distance sheet (That being AZ33).

What steps would I have to take to work towards fixing this?