Matching First Name in Range of Names

**phire** · 05-01-2009, 03:56 PM

Hi there,

I'm trying to find a way to check if the first and last name that are the content of cell A are anywhere in cell B and beyond. I've included an example:

http://tinypic.com/view.php?pic=28cpkr9&s=5

In the example A1 must match B1, C1 and C2.

Many thanks for any help.

**broro183** · 05-01-2009, 09:47 PM

hi,

At a glance, you may find the Find or Search functions useful. These are documented in the Excel Help files.

However, it is much easier for people to help with requests like yours if you attach an example file (rather than a picture). Can you please upload a file with sample data & an explanation of the expected results so we can provide more effective help?

hth
Rob

**phire** · 05-02-2009, 05:20 AM

Hi there,

I've uploaded an example of i want to do. My problem in using the Search or Find functions is that they are case sensitive, and my source data has titles (Miss, Mr.).

Again, thanks for the help.

**windknife** · 05-02-2009, 09:08 AM

Originally, I want to solve it by one cell, but it's complicated.
Therefore, I use more cell to solve this problem. Please, see attached.

I don't notice you want a VBA version. I just solve it using formula.

HTH
windknife

**phire** · 05-02-2009, 03:29 PM

Hi there,

Thanks for the great help. It works perfectly.

Thank you so much.

**broro183** · 05-02-2009, 09:42 PM

hi Phire

I'm pleased Windknife has been able to give you a solution (& shown you how the Search function can be used).

Originally Posted by phire

Hi there,
I've uploaded an example of i want to do. My problem in using the Search or Find functions is that they are case sensitive, and my source data has titles (Miss, Mr.).
Again, thanks for the help.

To clarify/correct your above comments for others who may read this post looking for solutions to their own problems, here's a quote from the Help files for Excel 2000:

FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text. You can also use SEARCH to find one text string within another, but unlike SEARCH, FIND is case sensitive and doesn't allow wildcard characters.

Rob