Data validation and an entry displayed

Hi all,

Ok I'm pretty new to VB in Excel. I currently have Excel 2003 (I know thats well old).

Right my question is how can I get an value to be automatically inserted into a coloumn after I select an entry froma data validation drop down options?

Let me clarify it further. Suppose I have created a data validation menu for a range of cells, say the menu consists of the following:

Apple
Banana
Pear
Orange

...and say that each fruit has a specific quantity, for example:

Apple 100
Banana 50
Pear 300
Orange 400

What I'd like to do is, when I select a fruit from the data validation menu the, ie Pear, than the relevant quantity (ie 300) is automaticaly inserted/diaplayed in the 'next' coloumn.

Hope this is clearer.

Thanks.