Find Jobs
Hire Freelancers

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.
Project ID: 6878536

About the project

3 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of TAIWAN
San Francisco, Taiwan
5.0
4
Payment method verified
Member since Dec 18, 2014

Client Verification

Other jobs from this client

Run Query for 4000 rows
$30-250 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.