vlookup
vlookup
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,329
    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

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