Find Jobs
Hire Freelancers

Excel vlookup/offset function to add

$25-30 USD

Cancelled
Posted almost 12 years ago

$25-30 USD

Paid on delivery
This is a fairly straightforward requirement. I have an Excel file with 2 worksheets (attached). The first sheet (Today's Matches) has a list of soccer matches together with some calculated odds for soccer scores. The relevant rows and columns have headers. The second sheet (Betfair) has an imported list of many matches with the correct score odds given by Betfair. Each match has in total 21 rows, including the first row that contains the names of the teams. They are similar but not exactly the same as the names in the Today's Matches sheet. I need the routine (or individual cell functions) to find the matches from the list in Today's Matches and extract from Column H in the Betfair sheet for the corresponding scoreline 0:0, 0:1 etc and place those odds into the correct column (CS:DI) in Today's Matches. Hopefully I've made myself understood and I've filled out a couple manually as an example. Please note that for some reason my excel sheet shows some of the scorelines as Jan-00 rather than 1-0 for example but others it doesnt change the formatting. This shouldnt make any difference to the final thing however. Any problems please ask as I may have not made myself understood fully.
Project ID: 2751369

About the project

1 proposal
Remote project
Active 12 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
1 freelancer is bidding on average $26 USD for this job
User Avatar
See private message.
$25.50 USD in 2 days
5.0 (6 reviews)
2.4
2.4

About the client

Flag of UNITED KINGDOM
Bristol, United Kingdom
5.0
63
Payment method verified
Member since Apr 1, 2005

Client Verification

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.