# Finding any of several names in an array

#### Haroon Salamat

##### New Member
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.

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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.

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?

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?

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

If you are not able to give us screenshots:
sensitive data changed
mark the workbook for sharing

Last edited:
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?

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

If you are not able to give us screenshots:
sensitive data changed
mark the workbook for sharing

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.

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.

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?

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

If you are not able to give us screenshots:
sensitive data changed
mark the workbook for sharing

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.

B
u
m
p

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

Replies
3
Views
431
Replies
3
Views
501
Replies
9
Views
576
Replies
0
Views
470
Replies
5
Views
301

1,221,127
Messages
6,158,101
Members
451,464
Latest member
Holden3

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back