Excel Formula

[trisher75]

Hi there,

I need some help. I want to creat a spreadsheet with a drop down menu in
column A when you selct from the menu I want an amount to appear in column B.
So then I can add a qty in the next column and multiply, it for billing.

Can anyone help me on this?

Thanks so much.
T.

 

[Ron Coderre]

Debra Dalgleish has examples of what you're trying to do at her website:
http://www.contextures.com/excelfiles.html#DataVal

Start with this file: DV0003 - Order Form

She has many other examples, too.


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP