lookup

Lauster_1999 · Mar 29th, 2002, 06:05 PM

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 · Mar 29th, 2002, 06:13 PM

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 · Mar 29th, 2002, 07:16 PM

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

Chris Davison · Mar 30th, 2002, 04:02 AM

and =SUMIF

Mar 29th, 2002, 06:13 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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! __________________ ~Anne Troy

Mar 29th, 2002, 07:16 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Lauster_1999: In reference to what Dreamboat suggested, explore using DATA\|SUBTOTALS feature -- this will nicely fit your needs also! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 06:05 PM	#1
Lauster_1999 New Member Join Date: Mar 2002 Location: England Posts: 1	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?

Mar 30th, 2002, 04:02 AM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	and =SUMIF