Excel Order Form

[1remark]

I have created an order form template already in Excel... what I would like
to do now is to be able to type in an Item number and have the description
and price automatically fill in the appropriate blanks. (Right now I am
manually typing in the item number, description and price.) The worksheet is
figuring out shipping and tax for me already.

I have a Price List in a separate file, but am having trouble trying to link
the two files to merge the information.

Help?!?!

 

[kid d]

You can either use drop down lists using the data validation tool (can be
just as painful), or in the cell where you want the description to appear,
enter formula w/ argument that draws from hidden table.

Or you can scrap and use MS Access...may be better for your application.

 

[1remark]

Thanks for the suggestion!! Since then, I have figured out a function to
pull the information that I want from another sheet in the workbook. The
information that is being pulled from a "price list" sheet changes on a
regular basis. This function seems to be the easiest way for me to keep my
"price list" up to date without having to make many changes to my order form.

FYI: There were two functions that I used.. one to find the description
and one to find the price. Here are the two functions:

To find the description based on an item number I type in cell C18:
=LOOKUP(C18,'Price List'!A:A,'Price List'!B:B)

To find the price associated with the item number I type in cell C18:
=IF(ISBLANK(C18),0,LOOKUP(C18,'Price List'!A:A,'Price List'!C:C))

These functions were then carried on down through the order form portion of
the file (i.e. C19, C20, C21, etc).

Thanks for your help!

 

[hiho63]

Hey 1remark,
First of all I have little experience working with Excel, but it sounds like
the spreadsheet you created is also one I am thinking about creating for my
father-in-law. I have an Excel book, but for me it is usually easier seeing
something and playing around with it. If it is not too much trouble could
you send me your spreadsheet or where I can find and example similiar. I
would greatly appreciate it.
Thank you, (e-mail address removed)