Hello I'm having trouble doing a formulae to solve a problem that i have
basically its this:

I have a drop down list in a cell in excel which has (coke, fanta,
sprite) what I would like to do is when i pick one from the list and
gets displayed in the cell i would like for the cell beside it to show
the price of that item, how can I do this I've tried IF functions but
doesnt work for me.

Thanks for your time
From John Wood


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=499930