D dmn Joined Apr 23, 2011 Messages 2 Reaction score 0 Apr 23, 2011 #1 Hi, I have a trouble with function MATCH in Excel 2010. It returns wrong value. Problem is to seen in attached sheet. Thanks for help Attachments match-wrong-value.zip match-wrong-value.zip 8.5 KB · Views: 108
Hi, I have a trouble with function MATCH in Excel 2010. It returns wrong value. Problem is to seen in attached sheet. Thanks for help
D dmn Joined Apr 23, 2011 Messages 2 Reaction score 0 Apr 23, 2011 #2 A half day I'm solving this. Now I realized that there is an argument for exact match. Solved. MATCH(A1;C1:C78) >> MATCH(A1;C1:C78,0)
A half day I'm solving this. Now I realized that there is an argument for exact match. Solved. MATCH(A1;C1:C78) >> MATCH(A1;C1:C78,0)