Results 1 to 3 of 3

Thread: Vlookup to bring back multiply values

  1. #1
    Board Regular
    Join Date
    Dec 2008
    Location
    Minneapolis, Minnesota
    Posts
    514
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup to bring back multiply values

    I am trying to write a formula that look at the header on the main tab for example AC6 contains a date 11/01/2020. I want it to look at the date in this tab, then go to tab titled Care Design and look the dates in column C and when it finds a match bring back the value in column I. The problem there may be more than one row where the date matches. I need the formula to bring the total of the two rows.

    For example rows 48 & 49 both have the dates 11/01/2020 in column C. The value in row 48 column I is 44,195.67 and the value in row 49 column I is 6,799.33 for a total value of $50,995 this is the value I need brought back to the main tab.

    This is the formula I am currently using, it stops at the first value it finds.

    =VLOOKUP(AC$6,'Care Design'!$C$22:$K$300,5,FALSE).

    Thank you

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    225
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Vlookup to bring back multiply values

    Hi Mldeuser,

    A little SUMIFS should do it.

    Here's my Care Designs tab:

    C D I
    1 Date Value
    46
    47 10/30/2020 22.00
    48 11/1/2020 44,195.67
    49 11/1/2020 6,799.33
    50 11/2/2020 22.00
    51 11/3/2020 22.00
    Care Design

    Here's the date in column AC and the SUMIFS in column AD

    AC AD
    1 Date Result
    6 11/1/2020 $50,995.00
    Main

    Worksheet Formulas
    Cell Formula
    AD6 =SUMIFS('Care Design'!I:I,'Care Design'!C:C,Main!AC6)
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  3. #3
    Board Regular
    Join Date
    Dec 2008
    Location
    Minneapolis, Minnesota
    Posts
    514
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup to bring back multiply values

    Thank you worked perfectly

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
  •