I'm trying to determine if any of the codes from Sheet1 Column A exist in each row of names in Sheet2, each of which have as many as 24 columns.
I do not need to know every match, just a logical yes/no for each row, if a match is found on any value in the column.