Annulleret

Excel vlookup/offset function to add

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.

Evner: Software Arkitektur, Windows Skrivebord

Se mere: problems with match, match problems, betfair problems, ask excel, Vlookup, excel vlookup, excel function, Excel Formatting, excel sheet formatting, excel contains, cell names, excel row column, excel column row, excel cell, excel file columns, betfair software, column row excel, contains function excel, cell add rows excel, extract function excel

Om arbejdsgiveren:
( 63 bedømmelser ) Bristol, United Kingdom

Projekt ID: #2751369

1 freelancer byder i gennemsnit $26 på dette job

gobublik

See private message.

$25.5 USD in 2 dage
(6 bedømmelser)
2.4