I want to match the Check Numbers from a range and to find the name to whom the check is issued. ,e.g., ch no. 12521 is lies between 12501 to 12600 and it has issued to AB. Ch number is given in sheet "CHK" and Range of check and and to whom the check has issued is given in sheet "BB". How I can find the name of the person?

The check numbers are not in ascending order. The Check numbers in sheet1 and range and Name is different sheet2.

A worksheet is enclosed.