Thanks to NBVC for the help in matching two big name lists, today I am trying to figure out a second function to match the numbers generated by the formula MATCH("*"&A1&"*",Sheet1!A:A,0) with the names they are associated with. To better explain: I have a list of numbers that correspond to the row on which a particular name resides, but I am not sure how I get these names to be matched up automatically with the numbers. I want to be able to quickly find that the numbers correspond with and mark them off so that if I forward the list with the relevant names highlighted.