Hi Experts
I am trying to use the following formula to match the values and get the result in cell N3.
=SUMPRODUCT(IF(ISNUMBER(MATCH(F3,$C$87:$E$88,0)),1,0),IF(ISNUMBER(MATCH(H3,$C$87:$E$88,0)),1,0),IF(ISNUMBER(MATCH(J3,$C$87:$E$88,0)),1,0),IF(ISNUMBER(MATCH(L3,$C$87:$E$88,0)),1,0)))
Real values are in cells C87,C88,E87 and E88 and the anticipated values are in cells F3,H3,J3 and L3. The anticipated values can be in any order.
Please help me matching the anticipated values with real values.
Regards
Bookmarks