Finding a Name

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
+-------------------------------------------------------------------
 
C

chandan12

Claus said:
Hi,

Am Sun, 28 Apr 2013 18:43:54 +0100 schrieb chandan12:
-

+-------------------------------------------------------------------+-

that is no worksheet but a text file


Regards
Claus Busch
Yes, I attached a txt file as I failed to upload xls sheet. I am gettin
a message that it is a invalid file and in attach file e segment I a
getting the following "
Valid file extensions: bmp doc gif jpe jpeg jpg pdf png psd txt zip"

Now I am attaching a zip file

+-------------------------------------------------------------------
|Filename: My Book_1.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=861
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top