Using either vlookup or IF function
Results 1 to 3 of 3

Thread: Using either vlookup or IF function
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2018
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Using either vlookup or IF function

    Hi,

    I have a query.

    I have a 2 tables of data, similar to below and basically I need to analyse how many pallets move in and out in a month, the raw data is inputted on the the bottom table but I want to know if there is a way to do a vlookup or IF function to basically add in the total number of pallets on a specific day that have been brought in or sent out against a specific part code.

    Part Code
    Date inbound
    01/06/2019 **FORMULA NEEDED**
    02/06/2019 **FORMULA NEEDED**


    Date Inbound/Outbound Part Code Pallet quantity
    01/06/2019 Inbound ABC123 2
    02/06/2019 Inbound ABC124 4


    If you have any questions to help work it out let me know

    thanks,
    Steven

  2. #2
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,239
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Using either vlookup or IF function

    Maybe something like this


    A
    B
    C
    D
    E
    F
    G
    H
    1
    Part Code
    ABC123
    Date
    Inbound/Outbound
    Part Code
    Pallet quantity
    2
    Date
    inbound
    01/06/2019
    Inbound
    ABC123
    2
    3
    01/06/2019
    2
    02/06/2019
    Inbound
    ABC124
    4
    4
    02/06/2019
    0
    5


    Formula in B3 copied down
    =SUMIFS(G$2:G$100,$D$2:$D$100,A3,E$2:E$100,B$2,F$2:F$100,B$1)

    M.

  3. #3
    New Member
    Join Date
    Jun 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using either vlookup or IF function

    Using Marcelo example and your data is formatted as a table the following should work as well.

    =SUMIFS(Table1[Pallet Quantity],Table1[Date],A3,Table1[Inbound/Outbound],B2,Table1[Part Code],B1)

Some videos you may like

User Tag List

Tags for this Thread

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
  •