Web Query - Search a Website Using Value of Cells as Search Criteria

Hi Guys,

I need help. I want to use Web Query in my Excel Sheet to show the Gross Sales of the movies that I am looking for.
Information about the movies are in columns A and B.
Column A contains the title, column B has the year when the movie was released.
Column C to E will displayed the Gross Sales of these movies based on the websites: the-numbers, boxofficemojo and imdb respectively.

How it should display the Gross Sales should be dynamic. Meaning, as the movie information in columns A and B changes, it should show the correct Gross Sales as taken from their respective websites.
I already made a search for similar topics in this forum, but they seem to be outdated already and thus don't apply.

Thanks in advance.

Hi Guys, any help?

I'm not sure exactly what you're looking for. Web Query returns XML results, but you have to know the full URL query string in order to get the info. I don't know that any of those websites return just the gross sales as the result of a search.

Hi Melvosh, thank you for looking into this. I know that excel is fully capable of doing a search based on cell values as search criteria, then picking the needed information from the result of that search.
I just dont know how.

I think the main issue is going to be ensuring the data you want is at the search URL. For example, the data you're looking for is not at boxofficemojo's search results screen, it's at the page for Captain Marvel. That URL is not intuitive. You'll likely have to know the exact URL to reliably pull data.

You can check the instructions at this Microsoft page to get you started on how to retrieve data from a webpage with Excel.

I hope this is in the right section.

Sorry about that, I wanted to transfer this thread over to that section.
Can you help with my question instead?