Pull Value from table on Excel.

So I've searched the forums and the interwebs and I have not yet found how to do this yet. I'm looking for a way to post a certain value between two drop down lists from a table of values up above. Essentially if I've got a name in A7 and a name in E1, I want to look up the value at E7 and have it post between the two drop down lists. The easiest way to look at it is to look at the excel sheet I have provided.

Example: I want to look up the distance between Ares(D1) and Harvest(A17) The outcome from the two drop down lists should output to tell me it is "161/3864"

If none of this makes sense I will try to answer any questions to the best of my ability

Thanks!

edit: For some odd reason I cannot find the excel sheet I posted to the forums. I'll try it again in the advanced editor.

Check out index match
http://www.contextures.com/xlfunctio...ml#IndexMatch3

Here is your example back, the green cells have the dropdown(data Validation)
http://www.contextures.com/xlDataVal01.html