'Function to have Excel search Google for "permanently closed" and IF listed as such, put a value?

I'm very new to excel and I'm enjoying learning it. I'm updating a business directory for work and have around 590 businesses to process. I have to look up whether each one is listed as "permanently closed" or not on google. I was wondering if there was a faster way to do this. From my research, I understand that I might need to use Python or VBA to create function on excel.

I have column A with all business names, and column B with either 1's (open), or 2's (closed). Since some business that are closed aren't listed as "permanently closed" on google, I'd like to keep the function clean and just have it automatically put a 2 next to the business name, only if it is listed as "permanently closed" on google. This will really cut down on time required to finish this job.

I'd like to add that this obviously isn't in my area of responsibilities, but I wanted to learn more.

Thanks for any and all help!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source