IF Function!?

N

Neo1

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
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
R

Ray A

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
 
R

Roland

=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.
 
Top