With that much data (>18k locations to search for per keyword and >23k keywords) I would advise against a formula driven solution - is VBA viable ?