From To

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

I would like to start a From and to database in Excel

The Column Heading in A will be From
The Column Heading in B will be to
The Column Heading in C will be Distance

The above will look like
A B C
1 From To Distance
2 Middlemore Downtown 18.4
3 Wiri Roskill 9.1
4 Hornby Dallington 5.7 and so on
What I require is a user of this database types in E1
and F1 the formula in G1 will give the answer.
As an example types Wiri in E1 and Roskill in F1 the
formula returns in G1 9.1

Thankyou.
 
I started to construct a full answer and then realised that the
data>autofilter function in excel does exactly what you want.

Click somewher in your list.
In the data menu, select filter and then autofilter.
you should find that some dropdown arrows now are shown on your title
row (to, from, distance)

Click on the arrow next to 'to'. See the list of values.

Select any one. The displayed list changes to match the chosen value.

Do the same on destination (select a value, note the dropdown for
destination will shrink/grow based on other fitlers in place) and you
will have your answer.
 
Back
Top