I am using Excel 2007 and here is an simplified example of what I need.


Items Price

Potatoes 4.35
Apples 5.55
Oranges 7.95
Onions 4.55
Carrots 3.75


Items Column is List for Valid entries in table below

Prices are the numbers I want entered when I enter the Item

If I enter Oranges from Dropdown List in A16 , I want Excel to automatically
enter the number 7.95 3 columns over in D16,or if it is quite a bit easier,
just 1 column over in cell B16

Example of table I want:

My Entries: Excel Enters

A16 Carrots D16 3.75
A17 Oranges D17 7.95
A18 Onions D18 4.55
A19 Onions D19 4.55
A20 Potatoes D20 4.35


Thanks so much for your help !