Drop downs w/ pop ups

[O]

How do you program excel so when a user selects an item on a drop down list, it would also automatically fill in two other related fields. For example

On field A1 is a dropdown list of two products (Product A & Product B). When a user selects Product A for field A1, the item number for Product A will automatically show up in field B1 and the price for Product A will show up in field C1.

 

[Debra Dalgleish]

Use VLookup formulas to return the address information in the adjacent
cells. There's a sample order form that uses this technique here:

http://www.contextures.com/excelfiles.html#DataVal

Look for 'Order Form' and download 'DataValOrder.xls'