Results 1 to 3 of 3

Thread: vlookup index match difficulties

  1. #1

    vlookup index match difficulties



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am have trouble creating an evaluation sheet for my employees. The goal is to print the total scans for each application in the second table for the respective ID number. I have tried nested vlookup along with if statements but run into the problem with vlookup when there are multiple of the same ID numbers since vlookup stops at the first match. I have looked into index match but am not familiar with the formulas and get lost in long equations. Any help would be greatly appreciated.




    A B C
    1 ID Application Total Scans
    2 1234 beltsplit 12500
    3 1234 primarysort 1300
    4 1234 vpls 4000
    5 2345 primarysort 3000
    6 2345 vpls 1200
    7 3456 beltsplit 12000
    8 3456 vpls 4200
    9 3456 primarysort 2300

    E F G H
    1 ID Beltsplit PrimarySort
    VPLS
    2 1234
    3 2345
    4 3456

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    888
    Articles
    0
    Excel Version
    Excel 2013
    In F2 cell (copy down and across)
    Code:
    =SUMIFS($C$2:$C$9;$A$2:$A$9;$E2;$B$2:$B$9;F$1)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,655
    Articles
    0
    Excel Version
    365
    A bog standard pivot table will give you this in less than 15 seconds:
    Click image for larger version. 

Name:	2017-01-30_212722.JPG 
Views:	5 
Size:	44.1 KB 
ID:	6353
    Attached Files Attached Files

Posting Permissions

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