I would like to return a "yes" or "no" if a specific value is found on a table, across multiple columns.
For example, I'd like to searching columns D-M across the below table:
Table for Excel Forum.JPG
For values matching those in column I in this table:
Table 2 for Excel Forum.JPG
If a matching value is found in the first table, I would like to return a "yes" in column J on the second table.
Any thoughts?
Bookmarks