C
chandan12
I want to match the Check Numbers from a range and to find the name t
whom the check is issued. ,e.g., ch no. 12521 is lies between 12501 t
12600 and it has issued to AB. Ch number is given in sheet "CHK" an
Range of check and and to whom the check has issued is given in shee
"BB". How I can find the name of the person?
The check numbers are not in ascending order. The Check numbers i
sheet1 and range and Name is different sheet2.
A worksheet is enclosed
+-------------------------------------------------------------------
|Filename: Test.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=859
+-------------------------------------------------------------------
whom the check is issued. ,e.g., ch no. 12521 is lies between 12501 t
12600 and it has issued to AB. Ch number is given in sheet "CHK" an
Range of check and and to whom the check has issued is given in shee
"BB". How I can find the name of the person?
The check numbers are not in ascending order. The Check numbers i
sheet1 and range and Name is different sheet2.
A worksheet is enclosed
+-------------------------------------------------------------------
|Filename: Test.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=859
+-------------------------------------------------------------------