Build a web query in Excel that searches a specified website based on parameters in Excel and returns a value into Excel.
$30-250 USD
In Progress
Posted over 9 years ago
$30-250 USD
Paid on delivery
I have a spreadsheet with three fields that I am searching by:
1) Producteurs (Example: Ballot Millot)
2) Appellations (Example: Meursault 1er Cru Genevrières)
3) Millésimes (Example: 2011)
I would like to concatenate these fields into one value (Example: ballot millot meursault 1er cru genevrieres 2011), and go to the the website [login to view URL], input the value into the main search field, and perform the search.
In the page that is returned, on the left hand column of the page is a field that reads: "Avg Price € 66 (750ml bottle, ex-tax)". In this example it is 66 Euro, but I would like for take the Average Price and return it into a column on my spreadsheet. In this case, it would be column G.
There will be instances in which the website will NOT return a value because the wine cannot be found, the name is typed incorrectly, or no one sells it. No matter the case, if the search returns no value, a null value should be returned into Excel.