Basically what I'm trying to do is on the first spreadsheet I need a "Yes" in the column under Eligible for Superstar. There is a bunch of names that I need to cross reference with the second spreadsheet. So if the names are on the second spreadsheet, then yes for Superstar, if no, then no..
Is this possible? It's on the same workbook
Thanks