My data table will have several thousand rows so below is asnippet to illustrate the problem.
Column G, ‘LOOKUPS’, is what I need to search out to match in ColumnB. There will be multiple instances of this number (not always) but most of the time, yes.
When it matches that number, it needs...