software

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: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=499930Have a table of Products and Prices and then use VLOOKUP for what you want.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;Neo1quot; gt; wrote in message
...
gt;
gt; Hello I'm having trouble doing a formulae to solve a problem that i have
gt; basically its this:
gt;
gt; I have a drop down list in a cell in excel which has (coke, fanta,
gt; sprite) what I would like to do is when i pick one from the list and
gt; gets displayed in the cell i would like for the cell beside it to show
gt; the price of that item, how can I do this I've tried IF functions but
gt; doesnt work for me.
gt;
gt; Thanks for your time
gt; From John Wood
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=499930
gt;
One way;
Create a table with your price structure. Define a name for the table. You
can then use a vlookup function to populate the price.
HTH

quot;Neo1quot; wrote:

gt;
gt; Hello I'm having trouble doing a formulae to solve a problem that i have
gt; basically its this:
gt;
gt; I have a drop down list in a cell in excel which has (coke, fanta,
gt; sprite) what I would like to do is when i pick one from the list and
gt; gets displayed in the cell i would like for the cell beside it to show
gt; the price of that item, how can I do this I've tried IF functions but
gt; doesnt work for me.
gt;
gt; Thanks for your time
gt; From John Wood
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=499930
gt;
gt;

=IF(A1=quot;cokequot;,1,IF(A1=quot;fantaquot;,2,3))where 1, 2, and 3 are the prices for Coke, Fanta, and Sprite.

Check you spelling, spaces, and capitalization closely.quot;Neo1quot; wrote:

gt;
gt; Hello I'm having trouble doing a formulae to solve a problem that i have
gt; basically its this:
gt;
gt; I have a drop down list in a cell in excel which has (coke, fanta,
gt; sprite) what I would like to do is when i pick one from the list and
gt; gets displayed in the cell i would like for the cell beside it to show
gt; the price of that item, how can I do this I've tried IF functions but
gt; doesnt work for me.
gt;
gt; Thanks for your time
gt; From John Wood
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=499930
gt;
gt;