move data to order sheet

[confused]

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]

Hi

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

Regards,

Per

 

[confused]

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]

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

 

[Gord Dibben]

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