drop down list (text) with adjoining value column

[rpowell1948]

Using Excel 2003, I am trying to develop a drop down list (in one column) of
model numbers that when selected will have a corresponding value in an
adjoining column. Example:

AHF2060 (included in one column) 512 (in adjoining column)
(this would be the drop down list) Each item in the
drop down list
would
have a corresponding

constant value for that model

number in the adjoining column

 

[Dean]

you will probably get better responses if you ask this question in an EXCEL
newsgroup. This one is for INFOPATH.