Returning a single result for a match under certain criteria

[ATHlaptop]

Hi there,

I have a table with dates, cash-flow type and the cash-flow number for that cash-flow type. Here is an example:

Value date; Cash-flow type; # cash-flow
row A ; B ; C
line
1 08/11/2021 ; capital call ; 1
2 14/12/2021 ; capital call ; 2
3 03/02/2022; capital call ; 3
4 16/05/2022; capital call ; 4
5 12/09/2022; distribution ; 1
6 01/02/2023 capital call ; 5
7 09/03/2023; distribution ; 2
8 09/03/2023; distribution ; 2
9 16/06/2023; capital call ; 6
10 04/07/2023; distribution ; 3

Now, I would like to retrieve the value date corresponding to # cash-flow 2 if the cash-flow type is "distribution". I have searched in other places of this forum but the results I found were giving me a string several results while I'd like only one result. I thik i'm not using correctly the INDEX/MATCH/IF combination. Thanks for the help!

 

[ATHlaptop]

Actually easily solved using MAXIFs, my bad, I don't konw how to delete this thread

 

[Sufiyan97]

You can post your own solution and mark it as a solution so in future others can have the solution if they have same query.

 

[ATHlaptop]

Actually easily solved using MAXIFs, my bad, I don't konw how to delete this thread

here is the solution found, using MAXIFS:

MAXIFS($A$1:A$10;$B$1:$B$10;"distribution";$C$1:$C$10;E2)
E2 being a cell containing "2", resulting in 09/03/2023

 

[Fluff]

As xl 2016 doesn't have the maxifs function, is your profile correct?

 

[ATHlaptop]

Thanks for bringing this to my attention, now corrected in my profile