This seems simple, however, I'm struggling. We have a master inventory list,
I want to make an order form on a separate sheet that when data is inputed to
the quantity to order columns on the master list it will move description,
quantity and weight columns to the order sheet. I can then fax the order
sheet without sorting the master then setting range. TIA

Hi

Have a look at the "LOOKUP" function, it should do what you need.

Regards,

Per

"confused" skrev i meddelelsen
...
This seems simple, however, I'm struggling. We have a master inventory
list,
I want to make an order form on a separate sheet that when data is inputed
to
the quantity to order columns on the master list it will move description,
quantity and weight columns to the order sheet. I can then fax the order
sheet without sorting the master then setting range. TIA

Per Jessen, I've been looking at that, however, it has been about 5 years
since I've done any real excel work, I can't figure out the procedure. If you
could give me an example that would be great.

"Per Jessen" wrote:

Hi

Have a look at the "LOOKUP" function, it should do what you need.

Regards,

Per

"confused" skrev i meddelelsen
...
This seems simple, however, I'm struggling. We have a master inventory
list,
I want to make an order form on a separate sheet that when data is inputed
to
the quantity to order columns on the master list it will move description,
quantity and weight columns to the order sheet. I can then fax the order
sheet without sorting the master then setting range. TIA

Hi

Here's an example:

On the Master sheet we have three columns : Unit #, Price, Weight (Column
A:C)

On the Order sheet we enter Unit # in A2, and in B2 we have this formula:

=LOOKUP(A2;Master!A2:A10;Master!C2:C10)

which will lookup the weight corresponding to the unit # entered in A2.

BTW: Click on the equal sign left to the formula line after entering
"=Lookup" to make excel help you createing your formula.

Hope that helps - otherwise write again.

Regards,

Per


"confused" skrev i meddelelsen
...
Per Jessen, I've been looking at that, however, it has been about 5 years
since I've done any real excel work, I can't figure out the procedure. If
you
could give me an example that would be great.

"Per Jessen" wrote:

Hi

Have a look at the "LOOKUP" function, it should do what you need.

Regards,

Per

"confused" skrev i meddelelsen
...
This seems simple, however, I'm struggling. We have a master inventory
list,
I want to make an order form on a separate sheet that when data is
inputed
to
the quantity to order columns on the master list it will move
description,
quantity and weight columns to the order sheet. I can then fax the
order
sheet without sorting the master then setting range. TIA

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for inputting
the data if need be.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Fri, 21 Mar 2008 11:10:00 -0700, confused
wrote:

This seems simple, however, I'm struggling. We have a master inventory list,
I want to make an order form on a separate sheet that when data is inputed to
the quantity to order columns on the master list it will move description,
quantity and weight columns to the order sheet. I can then fax the order
sheet without sorting the master then setting range. TIA