Hi all
I want to create a formula that will link multiple cells in a row based out which product number I choose from a drop down menu. A quick sample is below.
Basically I would have a database "Sheet 2", but in sheet 1 I want to choose from a drop down menu (I know how to do this bit), and then the Product Description, Size and Price will generate based on which item I select. Can this be done?
I want to create a formula that will link multiple cells in a row based out which product number I choose from a drop down menu. A quick sample is below.
Basically I would have a database "Sheet 2", but in sheet 1 I want to choose from a drop down menu (I know how to do this bit), and then the Product Description, Size and Price will generate based on which item I select. Can this be done?
| Sheet 1 | |||
| Product # | Product Description | Size | Price |
| Drop down menu | |||
| Sheet 2 (Data) | |||
| XYZ-10-TEST | Test sample for XYZ Product | 10" | £2.50 |
| XYZ-20-TEST | Test sample for XYZ Product | 20" | £5.00 |
| XYZ-30-TEST | Test sample for XYZ Product | 30" | £7.50 |
| XYZ-40-TEST | Test sample for XYZ Product | 40" | £10 |
