Hi everyone, I have an excel project that I could use some help with (this is also something that I have always wanted to know how to do).
I have a spreadsheet that has about 1,500 address on it. I would like to have Excel search the values in column F on a website, and return a particular item from the search results in column G.
The value that I am trying to return for each address is "property type", for example "Industrial | Warehouse" for 10 Herrmann Pl. Once it completes this lookup, I would like it to move onto the next line.
Any help would be greatly appreciated.
I have a spreadsheet that has about 1,500 address on it. I would like to have Excel search the values in column F on a website, and return a particular item from the search results in column G.
The value that I am trying to return for each address is "property type", for example "Industrial | Warehouse" for 10 Herrmann Pl. Once it completes this lookup, I would like it to move onto the next line.
Any help would be greatly appreciated.