I am not able to follow what you want. Pl give full data in its original format and give the expected result with suitable explanation. Upload new sample file. In the first post you compared data in the same row. That is what the result says. That is A2 is compared to B2, A3 to B3 etc. Do you want to compare B2 with full range A2:A4 . B3 also with A2:A4. Same applies to second table also. Pl clarify.