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

Have 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 :-)
------------------------------*------------------------------*----------------


"Neo1" wrote in message
...

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

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

"Neo1" wrote:


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

=IF(A1="coke",1,IF(A1="fanta",2,3))


where 1, 2, and 3 are the prices for Coke, Fanta, and Sprite.

Check you spelling, spaces, and capitalization closely.


"Neo1" wrote:


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