Help with INEX / MATCH or another solution to perform LOOKUP, don't think VLOOKUP will wor

[JRay0108]

So I'm trying to lookup data where the date is listed multiple times in the column because the data that I need returned is also down a column and not across rows where you could use a VLOOKUP. Very herd to explain but attached a simple example of what I am working with.

Using the formula:

=INDEX($D:$D,MATCH($F3,$B:$B,1))

Not working remotley as expected.

Any help is GREATLY appreciated!

excel help.jpg

[daddylonglegs]

It might be simplest to use SUMIFS, i.e. this formula in G3 copied across and down

=SUMIFS(D:D,B:B,$F3,C:C,G$2)

[JRay0108]

Worked like a charm.

Thank you!