Help, #REF! error

Occasional Contributor


Is there any problem with B15:D16? The others work well though.

2 Replies

@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

@Riny_van_Eekelen thank you, i didn't realized the results were wrong.