Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: vlookup

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

    Default

    I am trying to use a vlookup to look at four separate sheets at the same time in order to create a database where I copy and paste the information on another sheet in order to sort various ways to create charts. I want to be able to type the LOT NUMBER in and pull all the other information in. The operators will be entering this information in based on their respective machine. I will then enter the lot number at the end of the shift onto another worksheet. I hope this makes sense

    LOT NUMBER DATE STYLE SHIFT UCL "UPPER
    STANDARD" AVERAGE "SAMPLE
    AVERAGE" "LOWER
    STANDARD" LCL UCL RANGE AVERAGE LCL

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,423
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    - What formulas have you tested?

    - What is the layout of your information?

    - What result do you require?

    =vlookup(a1,data1,2,0)+vlookup(a1,data2,2,0)+
    vlookup(a1,data3,2,0)+vlookup(a1,data4,2,0)

    The data1 etc are named ranges for your information on the 4 sheets.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you can, email a copy of your spreadsheet, and I'll take a look at it.
    Regards, Duane
    Office2010 in Win7

Some videos you may like

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
  •