lookup
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: lookup

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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?

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    and =SUMIF

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com