Hi everyone,
I'm looking for a array formula which shows the latest delivery date of a purchase order in the RESULT column.
I need to use the Match function since the positions of columns can always change.
The exercise is as follow:
I came up with the following formula. The problem is that I don't know how to apply the MAX function.
=INDEX($A$3:$B$6;MATCH($D4;$A$3:$A$6;0);MATCH(E$2;$A$2:$B$2;0))
May I ask you for help please?
Thank you in advance.
I'm looking for a array formula which shows the latest delivery date of a purchase order in the RESULT column.
I need to use the Match function since the positions of columns can always change.
The exercise is as follow:
I came up with the following formula. The problem is that I don't know how to apply the MAX function.
=INDEX($A$3:$B$6;MATCH($D4;$A$3:$A$6;0);MATCH(E$2;$A$2:$B$2;0))
May I ask you for help please?
Thank you in advance.