function MATCH returns wrong value

dmn

Joined
Apr 23, 2011
Messages
2
Reaction score
0
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

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)
 
Back
Top