lookup spreadsheet.

sabu

New Member
Joined
Dec 8, 2002
Messages
3
:rolleyes:

This might be quite mundane to a lot of users, but as a mug learner I would like to be able to keep a list of names which I would need to add to regularly and be able to have an excel sheet with lots of names and be able to ask to find in the latter list any that is within my list of kept names. I guess you could lliken it to having a list of all my school friends names, and then putting in all the names in the electoral roll for a certain area and wanting to know if any of my friends names turn up in that electoral roll. I Hope I have explained myself... I have also heard it referred to as a black book list.


Thanks in advance.


Norm :p
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Insert a new sheet that you can name Admin.
Enter all names of interest (your first list) in a column, say in A from A10 on. Select these names, go to the Name Box on the Formula Bar, type MList, and hit enter.

Now you can use...

=ISNUMBER(MATCH(C1,MList,0))

where C1 is a cell in some sheet housing a name. This formula checks whether C1 is in MList.
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

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
Back
Top