Excel Formulas - using array formula across sheets

Question

I'm looking for assistance in creating a formula for the following:

• In Worksheet 1, Cell A1 has a dropdown menu of place names where a person will travel from (i.e. Place A).  Cell B1 has a dropdown menu of place names where a person will travel to (i.e. Place B)
• I want to create the formula in Cell C1 that will read from Worksheet 2 in the same document.
• Worksheet 2 contains Column A, with a list of place names to travel from (i.e. Place A, Place B, Place C, etc.....).  In Column B of this same Worksheet I have a list of place names to travel to (i.e. Place A, Place B, Place C, etc....).  Column C contains the number of kilometers from one place to the next (see below).

How can I get Worksheet 1 to read from Worksheet 2 based on the place names selected from the dropdown menus in Worksheet 1?

Any help you can offer would be appreciated.

Place A	Place B	177
Place B	Place C	271
Place C	Place D	146
Place D	Place E	275
Place E	Place F	372
Place F	Place G	189

Answer 1

Hi,

It looks like the numeric columns has some invisible entries in some/all cells.  Remove those entries.

Answer 2

Hi,

I had another approach i mind and worked it out yesterday but did post it yet.

You can download the file here: 123KimD

Further explanation in the file.

Answer 3

It worked!!!!!  :)

Thank you so much for your patience with me.   Really appreciate your help.

:)