Results 1 to 2 of 2

lookup spreadsheet.

This is a discussion on lookup spreadsheet. within the Excel Questions forums, part of the Question Forums category; This might be quite mundane to a lot of users, but as a mug learner I would like to be ...

  1. #1
    New Member
    Join Date
    Dec 2002
    Location
    Tamworth
    Posts
    3

    Default lookup spreadsheet.



    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

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,900

    Default Re: lookup spreadsheet.

    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.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com