Hi,
I'm trying match values (and set a Yes / No result) from values in two very large lists.
List 1 (approx 170,000 rows) contains the 'Find What' values
List 2 (approx 980,000 rows) contains the 'In What' values
Values in list 1 will be unique in list 2, but not all values in list 1 will appear in list 2.
The values in each list are all 16 character stings
This is a one-off otherwise I'd probably import into a AccessDB
Using formulas is taking an absolute age to calculate using MATCH function, so I'm wondering if coding is the better angle.
Any ideas/insight/methods welcome.
(Using XL07, on Core2Duo)
Bookmarks