how to set up one cell that assigns a value based on the value of another cell

[Joseph]

I work in the accounting department of a hospital that has 37 facilities,
each with their own ID. What I want to do is have one cell contain a drop
list so that the user can choose a facility and have another cell that
automatically inputs the correct ID based on what facility has been chosen.
The "If" function would work great only if it wasn't for its limitation on
nesting. I know how to produce the cell with the drop list. What I want to
know is how can set up another cell so that it automatically assigns an ID
that corresponds to the correct facilility.

Thanks
Joseph

 

[Anne Troy]

Hello, Joseph. I have loaded a similar workbook, except it's part numbers
that return prices. You can use the same features.
Here's the workbook:
http://www.myexpertsonline.com/freedls/pricelist.xls
Here's the Data Validation feature:
http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm
Here's VLOOKUP:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Joseph]

Hi Anne,

Thank you so much. I got it to work. This is so cool.

Joseph