I was wondering how I can have a drop down list in a cell that has about 100
items in the drop down, and when you select the drop down item you want it
fills in all of the other columns relating to that item.

For example, on this example there would be 100 other items but when I am in
column 1 I want a drop down list and have it pull in column 2 and 3.


Item Description Price

A Testing Item 5.00

Thanks a bunch