ExcelBanter - Finding a Name

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Finding a Name (https://www.excelbanter.com/excel-worksheet-functions/448671-finding-name.html)

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.

Hi,

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

A worksheet is enclosed.

+-------------------------------------------------------------------+
|Filename: Test.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=859|
+-------------------------------------------------------------------+

that is no worksheet but a text file

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Quote:

Originally Posted by Claus Busch (Post 1611472)

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

Now I am attaching a zip file.