Is there formulas which set text to equal a number?

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

Guest

I am trying to create text and when selected from a drop down list a specific
$ amount is input in the adjacent cell dependent on which item was selected
from the drop down.
 
If there are only a "few" different items you can use something like this:

=IF(A1="apples",25,IF(A1="grapes",35,IF(A1="pears",28,"")))

If you have many different items then you should create a 2 column lookup
table like this:

...........D..........E
1...apples.......25
2...grapes......35
3...pears........28

Then the formula would be:

=VLOOKUP(A1,D1:E3,2,0)
 
Back
Top