I have a list of Product ID's (approx 16,000 unique values), and I need to see if these products show up within 21 other .CSV workbooks. If they do, I need to return cells from various columns corresponding to these product ID's. All workbooks are formatted exactly the same.
This is the...