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

[richardking]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Movie Title[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]The-numbers.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 160"]
<tbody>[TR]
[TD="class: xl65, width: 160"]Boxofficemojo.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 84"]
<tbody>[TR]
[TD="class: xl65, width: 84"]Imdb.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Captain Marvel[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]2019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Spider-man[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]2002[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Toy Story[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]1995[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Expected Results based from the data of the different websites

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Movie Title[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]The-numbers.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 160"]
<tbody>[TR]
[TD="class: xl65, width: 160"]Boxofficemojo.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="class: xl65, width: 85"]Imdb.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Captain Marvel[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]2019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$266,213,933[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$266,213,933[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 85"]
<tbody>[TR]
[TD="class: xl65, width: 85"]$196,895,933[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Spider-man[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]2002[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$403,706,375[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$403,706,375[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$403,706,375[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]Toy Story[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl65, width: 43"]1995[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$191,796,233[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$191,796,233[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]$191,796,233[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...-using-value-of-cells-as-search-criteria.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.