I have a spreadsheet where I have a master list and three additional tabs (see attached "Starting Point.xlsx" in the .ZIP file) The master is the aggregate of all unique values of the tabs. I need to do a lookup that looks for the value in column A and if it finds a corresponding match in tabs 2, 3, or 4 that it sets a flag that the entry was found in that list. I have a column on tab 1 for each subsequent tab. The lookup values are all text and the number of entries could vary for each tab. The flag doesn't have to be "yes" or "no", it could be 1 and 0. It should end up looking like "Ending Point.xlsx" in the .ZIP file.
Thanks in advance for your help.
Bob