Creating a Purchase Order Form

[Dannyboy]

I am trying to create a Purchase order form in which the first colum is to be a drop down box of the list of available products. Once they make their selection other fields are the spreadsheet will auomatically fill, such as product ID number, product type and so forth. I've tried using the Data Validation but don't want the users to see those fields. I would rather have the Prodcut "Table" so to speak on a seperate spreadsheet. The user will be able to enter multiple products as well.

So it will look someothing like this

Product Product ID (auto fill based off the Product selected) Product Nam
Apples (drop down list) A98292ABD0 Washington Red Apple
Peaches(drop down list) P299239B0D9 Georgia Pink Peache

Any help would be appreciated. Thanks in advance.

 

[Charlie]

You can use a VLook up for this, for example:
=Vlookup(A1,Sheet2!$a$1.$c$100,2,False)

This will lookup the value in A1 on sheet1 in a table on
sheet2, assumming the table is in A1.C100 , then return
the value in the 2nd column of the corresponding lookup
value.

Excel help has a few examples on this.

LOL

Charles O'Neill

-----Original Message-----
I am trying to create a Purchase order form in which the

first colum is to be a drop down box of the list of
available products. Once they make their selection other
fields are the spreadsheet will auomatically fill, such as
product ID number, product type and so forth. I've tried
using the Data Validation but don't want the users to see
those fields. I would rather have the Prodcut "Table" so
to speak on a seperate spreadsheet. The user will be able
to enter multiple products as well.

So it will look someothing like this:

Product Product ID (auto fill

based off the Product selected) Product Name

Apples (drop down list)

A98292ABD0
Washington Red Apples

Peaches(drop down list)

P299239B0D9
Georgia Pink Peaches

 

[Debra Dalgleish]

You can store the data validation source list on a different sheet, if
you name the range that contains the list. There are instructions here:

http://www.contextures.com/xlDataVal01.html

Then, use VLookup formulas to return the related data. There are
examples here:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for Order Form