functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok Im having a tough time. I am preparing a worksheet to use for estimates. I
am making a drop down list to choose from and would like to be able to have
the answer display an amount. Example:

Pick: Apples, Cherries or Bananas.

If user selects apples, the cell would populate with .50 (so i can do a
formula at 50 cents each)
If they select cherries; .75
And so on...

I havent found where I can use a formula that will see "cherries" and make
it a NUMBER!

Can anyone please send reply to my email (e-mail address removed)

THANKS!
 
NeeeedHelp,

What you want can be accomplished with the vlookup function.

To use it, you will need to set up a separate table for the apples
cherries etc in on column (the first column) and in the next column th
prices.

Teh Vlookup function will allow you to lookup 'cherries' in the tabl
and return the corresponding price. Excel help has a goo
explanation, if you get stuck - post back to the forum and we wil
assist
 
Back
Top