Mar 15 2023 07:04 PM - edited Mar 15 2023 07:25 PM
Is there any problem with B15:D16? The others work well though.
Mar 15 2023 10:29 PM
@DumbHandsomeDonkey6969 In fact, all results of the formula are wrong, I believe. And the #REF! error occurs only for CP as it results in referencing the third row in an array that only has two. You need to change the order of the MATCH statements
Mar 16 2023 01:47 AM
@Riny_van_Eekelen thank you, i didn't realized the results were wrong.
