B
Brent
I have a workbook containing (2) worksheets.
Worksheet 'A' contains various calendaring info. I use this to keep track
of what schools I visit on what date, and how many miles it is from my
office. I populate Column A with the names of the schools I visit. Column L
needs to contain the mileage info.
Worksheet 'B' contains a list of the schools, along with the mileage
information (no. of miles from my office). Column A of this worksheet
contains the schools listed in alphabetical order by row. Column B of this
worksheet contains the respective mileage info.
What I am trying to accomplish is a formula that does the following:
As I type the name of the school in cell A1 (worksheet A), cell L1
(worksheet A)populates with the mileage info from worksheet B.
Any ideas?
I am thinking that the name I type worksheet A) must match the name(s)
listed in Column A (worksheet B) ?
As I type the school name into Column A (worksheet A), can Excel use
predictive feature to populate as I type? (i.e. - type 'Wash' , Excel
responds by predicting 'Washington') ?
Thanks in advance!
Brent
Worksheet 'A' contains various calendaring info. I use this to keep track
of what schools I visit on what date, and how many miles it is from my
office. I populate Column A with the names of the schools I visit. Column L
needs to contain the mileage info.
Worksheet 'B' contains a list of the schools, along with the mileage
information (no. of miles from my office). Column A of this worksheet
contains the schools listed in alphabetical order by row. Column B of this
worksheet contains the respective mileage info.
What I am trying to accomplish is a formula that does the following:
As I type the name of the school in cell A1 (worksheet A), cell L1
(worksheet A)populates with the mileage info from worksheet B.
Any ideas?
I am thinking that the name I type worksheet A) must match the name(s)
listed in Column A (worksheet B) ?
As I type the school name into Column A (worksheet A), can Excel use
predictive feature to populate as I type? (i.e. - type 'Wash' , Excel
responds by predicting 'Washington') ?
Thanks in advance!
Brent