Finding any of several names in an array

Haroon Salamat

New Member
Joined
Aug 27, 2014
Messages
4
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.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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?
 
Upvote 0

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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.
 
Last edited:
Upvote 0

Haroon Salamat

New Member
Joined
Aug 27, 2014
Messages
4
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.
 
Upvote 0

Haroon Salamat

New Member
Joined
Aug 27, 2014
Messages
4
ADVERTISEMENT
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.
 
Upvote 0

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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.
 
Upvote 0

Forum statistics

Threads
1,196,015
Messages
6,012,861
Members
441,737
Latest member
bijayche

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top