Find Jobs
Hire Freelancers

Excel vlookup/offset function to add

$25-30 USD

Annulleret
Slået op næsten 12 år siden

$25-30 USD

Betales ved levering
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.
Projekt-ID: 2751369

Om projektet

1 forslag
Projekt på afstand
Aktiv 12 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
1 freelancere byder i gennemsnit $26 USD på dette job
Brug Avatar.
See private message.
$25,50 USD på 2 dage
5,0 (6 anmeldelser)
2,4
2,4

Om klienten

Flag for UNITED KINGDOM
Bristol, United Kingdom
5,0
63
Betalingsmetode verificeret
Medlem siden apr. 1, 2005

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.