Finding any of several names in an array

[Haroon Salamat]

I have what may be a simple question. I have a list of say 10 names and I want to find any of these names in a column of 500 names which may contain one or more instances of the names for which I am searching.
Thanks for your help.

 

[Aladin Akyurek]

I have what may be a simple question. I have a list of say 10 names and I want to find any of these names in a column of 500 names which may contain one or more instances of the names for which I am searching.
Thanks for your help.

Something like:

=SUMPRODUCT(COUNTIF(A:A,List))

=ISNUMBER(LOOKUP(9.99999999999999E+307,SEARCH(List,A2:A100)))

Or is it a completely different calculation/result what you need?

 

[hiker95]

Haroon Salamat,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


3a. What is the worksheet name that contains a list of say 10 names?

3b. What is the first cell that contains a list of say 10 names?

4a. What is the worksheet name that contains the names in a column of 500 names?

4b. What is the first cell that contains the names in a column of 500 names?

5a. Where are the results from the above going to be placed?

5b. What are the results to look like?


So that we can get it right the first time:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
1. MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970

2. Excel Jeanie
Download


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[Haroon Salamat]

Haroon Salamat,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


3a. What is the worksheet name that contains a list of say 10 names?

3b. What is the first cell that contains a list of say 10 names?

4a. What is the worksheet name that contains the names in a column of 500 names?

4b. What is the first cell that contains the names in a column of 500 names?

5a. Where are the results from the above going to be placed?

5b. What are the results to look like?


So that we can get it right the first time:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
1. MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970

2. Excel Jeanie
Download


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

I am using Windows7 and Excel 2010. Both Lists are on the same work sheet. The names I wish to find are B1:B10 and the list I wish to search is A1:A500. The lists are only text and I only need to find them.

 

[Haroon Salamat]

I am using Windows7 and Excel 2010. Both Lists are on the same work sheet. The names I wish to find are B1:B10 and the list I wish to search is A1:A500. The lists are only text and I only need to find them. What I am trying to do is use the find function but to find any of 10 different names.

 

[hiker95]

Haroon Salamat,

In order to continue, and, so that we can get it right the first time, we need to see your raw data:


Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?


To post your data, you can download and install one of the following two programs:
1. MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970

2. Excel Jeanie
Download


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.


If you are not able to provide screenshots, per the above, or, provide your workbook/worksheet, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[Haroon Salamat]

B
u
m
p

 

[Aladin Akyurek]

B
u
m
p

Why do you bump? You didn't even consider all of the replies...