Hello,

Using excel 97, I currently have a drop down box which list location names. The problem is the location names are very generic (only part of the location info). What I would like to do is have a drop down list actually list the full location name but populate the field with the generic name when selected. I could add another column but this file will be used as import data and the extra field is not part of the extract layout.

Ex.

Generic name:T100

Full location name: Trumbull 100 (specific trumbull address)

User's would select trumbull 100 from the drop down list, but the name T100 would actually populate the field. I tried to reference the generic range but keep on getting a circular reference error. Can this be done?