Lookup each value in a list based on another column with duplicates

[Drew_]

Hi all.

I have a list of dates that contains some dates twice. I will provide some sample data below:

09/01/17 A/P
09/01/17 IM
09/05/17 A/R 11,867.00
09/07/17 IM
09/07/17 IM
09/07/17 IM 09/05/17 250.00
09/08/17 IM 09/07/17 620.00
09/08/17 A/R 900.00
09/08/17 ACH055
09/08/17 ACH055
09/08/17 ACH056
09/08/17 450.00
09/08/17
09/08/17



I would like to lookup the dollar values (third column here, call it C) for each specific date (Column A) and type of transaction (Column B). When I do INDEX/MATCH, it only looks up the first occurrence of the date and returns that value for every duplicate. I tried using OFFSET with it and that did not work either.

I essentially just want to return each unique value for each line item. Please let me know if I was not clear enough. Any help is appreciated, thanks

EDIT: I tried spacing out the data and it works fine when I edit it, but when I post it, it goes back to being cluttered. Let me know if it is not clear enough, thanks

 

[StephenCrump]

I tried spacing out the data and it works fine when I edit it, but when I post it, it goes back to being cluttered.

Part B here shows you a couple of ways you can post screenshots: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

It's not clear so far what your data looks like, but if it's guaranteed that there can be only one dollar value per date/transaction type, then perhaps:

D17: =SUMIFS(C$1:C$14,A$1:A$14,B17,B$1:B$14,C17)

Excel 2010
	A	B	C	D
1	1 Sep 2017	A/P
2	1 Sep 2017	IM
3	5 Sep 2017	A/R	11,867.00
4	7 Sep 2017	IM
5	7 Sep 2017	IM
6	7 Sep 2017	IM	250.00
7	8 Sep 2017	IM	620.00
8	8 Sep 2017	A/R	900.00
9	8 Sep 2017	ACH055
10	8 Sep 2017	ACH055	777.00
11	8 Sep 2017	ACH056
12	8 Sep 2017	xxx	450.00
13	8 Sep 2017
14	8 Sep 2017
15
16		Find:		Result:
17		7 Sep 2017	IM	250.00
18		8 Sep 2017	ACH055	777.00
Sheet1