# Thread: Vlookup to bring back multiply values Thanks:  1 Post #5345021 (1) Likes: 0

1. ## 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. ## 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

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

Worksheet Formulas
Cell Formula

3. ## Re: Vlookup to bring back multiply values

Thank you worked perfectly