Matching from a Range

Originally Posted by chandan12

I am not getting the same result. Look at my worksheet. I have just changed the check numbers in sheet "CHK" and out of 38 entry only 8 are giving correct result. Hope your guidance.

Hi chandan12!
I compared the formula in #2 with fomula in #37 when the numbers are in ascending, so i didn't find the diferrence. Can you upload your File with the result was type by hand?