lookup

[Lauster_1999]

I am working on a school project on Excel 2000 and i am wanting to lookup values from one workbook and copy them across to another. However the system is quite complex. I have a mail-order company with four different order methods-Phone,Fax,Email and Regular mail.On my sales workbook, I have a list of all the invoice details, including order method and order total and many other order details. However I want to create a summary sheet on a seperate workbook, which will lookup the sales values in the sales workbook and sum up the values for each seperate order method. I know there must be some processing between the vlookup and the raw data, but i dont know how to process this and i am unsure of the code for the vlookup. Can someone explain if there is a solution to this problem?

 

[Anne Troy]

I don't think this requires vlookup at all.

Rather....

For each workbook, put a totals column as the TOP row, where it totals your orders.

Then, from the first workbook, select those cells and copy them.

Go to your summary, and hit Edit-Paste special-Paste link. Do this once for each workbook.

Now, you can even do a summary of the *summary* info you just created.

Does that help? I hope so!

 

[Yogi Anand]

Hi Lauster_1999:
In reference to what Dreamboat suggested, explore using DATA|SUBTOTALS feature -- this will nicely fit your needs also!

 

[Chris Davison]

and =SUMIF