Forum Discussion
Help, #REF! error
Is there any problem with B15:D16? The others work well though.
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.