I have a worksheet that I am making, and I have put drop down tables in it.
Now lets say I select Apples from the drop down menu, I want it to display
the price for the apples in the next colum, and if I choose Oranges, the
price for oranges, and so on. I am racking my brain on how to do this, and I
really don't know how to look it up. Any help that anyone could give would
be great.

Thanks,