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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a drop down that adds up a price 1
Counting highest values within groups of four 3
Nested formula...I think 1
Help with =SUMPRODUCT 3
Help adding letters in column 2
Lookup function for a value that has multiple instances 4
How to choose maximum value 7
max 7

Back
Top