Find Jobs
Hire Freelancers

Excel vlookup/offset function to add

$25-30 USD

已取消
已发布将近 12 年前

$25-30 USD

货到付款
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.
项目 ID: 2751369

关于此项目

1条提案
远程项目
活跃12 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
1威客以均价$26 USD来参与此工作竞标
用户头像
See private message.
$25.50 USD 在2天之内
5.0 (6条评论)
2.4
2.4

关于客户

UNITED KINGDOM的国旗
Bristol, United Kingdom
5.0
63
付款方式已验证
会员自4月 1, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。