Use SQL queries in excel macro

[vibhor]

Hi,

I am trying to create a macro to find the cities from an address in a cell. For that I have made a list of cities in another sheet of that workbook. Now I want the macro to go through each and every cell in the range of cities I have defined and find that in my given address and give me the output as the city name in cell next to the address if it finds a match. Now this will take a lot of time as the range of cities can be around 20,000. So can use any function to make it quicker or SQL query to make it run faster.

Please refer to the attached file. I just want to know if it can be done or not. I can share more details if required and it seems possible.

Thanks,
Vibhor