Hard to say, sounds like more a VLOOKUP or INDEX job. If you want to, mail
me the file on

Remove NOSPAM of course,
Regards,
"MarthaSue" wrote in message
...
Creating a field ticket on excel . . .in one area of the worksheet the
user
will choose between 5 diferent choices (length of tubing)in a drop down
bar.
Each choice (length of tubing) has a different price (5 corresponding
prices)associated with it. I am trying to use the IF function to allow
the
user to chose the length of tubing from a drop down bar and have EXCEL
automatically enter a price in the subtotal column of the ticket. Each
length of tubing has a corresponding price associated with it. I have
tried
this as a formula . . . but surprise . . . it's not working. (=IF(E40=73.0
mm
Tubing,27,IF(E40=114 mm Tubing,30,)). I have tried to enter this formula
in
the subtotal column, which is U40. Please bare with me, as I am just
flying
by the seat of my pants, I don't know this program very well. Any help
would
be greatly appreciated.

Thanks,
Shar