Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet formula - auto populate
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto populate an invoice from data in an existing worksheet | Excel Discussion (Misc queries) | |||
Lookup list from different worksheet & auto-populate multiple cell | Excel Discussion (Misc queries) | |||
Auto populate one worksheet from other worksheets | Excel Worksheet Functions | |||
formula to auto populate zip when city is typed in Excel | Excel Worksheet Functions | |||
I want to conditionally auto-populate a summary worksheet | Excel Discussion (Misc queries) |