Hello all, glad to join this forum.

I'm working on an Excel database for placement history at a college and am wondering if there's a solid means by which to automatically fill cells as such:

I have two fields, the programs of graduates and the divisions of graduates, is there any way for Excel to remember from previous entries that certain programs correlate with divisions and automatically complete the division field as such? Or do I have to create some sort of list for it to refer to, listing all of the programs and their respective divisions.

I also have the graduates' employers and the locations of the employers in city, state, and zip. Is it possible for Excel to remember employers and automatically fill their locations? Or perhaps automatically fill the zip and state by listing the city, etc.

I'll have to apologize for having a superficial and strictly rudimentary understanding of Excel and many of its features, please bear with me.

Thank you very much