Find Jobs
Hire Freelancers

Do some Excel Work

$15-25 CAD / hour

已完成
已发布超过 8 年前

$15-25 CAD / hour

I am creating an Excel spreadsheet that requires VLOOKUP referencing - and possibly other advanced Excel tools. I have formatted the overall worksheets but need help with bringing it all together with lookup codes. This will be an ongoing project as I want to add additional features as the business grows. I want to automate as much as possible. This initial work won't take too long. Q - When doing VLOOKUP I keep getting #N/A error messages because fields are empty. Can empty fields return a result that is simply BLANK?
项目 ID: 8885111

关于此项目

65提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi! The error due to blank cells can be avoided using IFERROR or IF(ISERROR functions. Please share the file and I am ready to start working on it right now.
$15 CAD 在3天之内
5.0 (382条评论)
7.5
7.5
65威客以平均价$19 CAD/小时来参与此工作竞价
用户头像
A proposal has not yet been provided
$25 CAD 在2天之内
4.9 (321条评论)
7.3
7.3
用户头像
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$22 CAD 在1天之内
4.9 (230条评论)
6.9
6.9
用户头像
Hi There, My name is Priyal. I’ve read your brief and happy to discuss the project in more detailed. I am an expert in all advanced excel formulas including vlookup, hlookup etc. If you'd like to view my qualifications, experience and previous work, take a look at my Freelancer Portfolio I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards,
$15 CAD 在4天之内
5.0 (195条评论)
6.8
6.8
用户头像
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
$22 CAD 在3天之内
4.9 (162条评论)
6.7
6.7
用户头像
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$15 CAD 在1天之内
5.0 (256条评论)
6.5
6.5
用户头像
Hello, I am Excel and VBA expert. I can write a macro (if needed) and/ or formulas. P.S. VLOOKUP can return #N/A error, but you can easily avoid this error Regards Jan
$15 CAD 在3天之内
5.0 (94条评论)
6.0
6.0
用户头像
Hi, I am very good in EXCEL and VBA programming so I can help you with this project in minimal time. as I have worked on similar projects many times :) Regards.
$15 CAD 在2天之内
5.0 (26条评论)
5.3
5.3
用户头像
Hi, I am a scientist by profession with extensive experience in creating Excel platforms for reformatting, organising and analysing large data sets. I believe I will be able to help you create an attractive, easy-to-use and error-free spreadsheet , and I will be more than happy to help expand its functionality wherever needed in the future. I have a lot of experience with VLOOKUP referencing. The #N/A error can be fixed by simply adding in an =IF(ISERROR(XXX)=FALSE, logic gate which evaluates to a blank if the formula would otherwise return an error. Please check my portfolio for other examples of complex Excel tasks I have undertaken in the past. Thanks for your consideration, Dan
$20 CAD 在3天之内
5.0 (52条评论)
5.1
5.1
用户头像
Hi, For your problem you must use VLOOKUP with IF and ISERROR The format is like this =IF(ISERROR(VLOOKUP...),"",VLOOKUP(same vlookup)) I am not interested in hourly contracts, if you especially need macro solutions find me... Regards,
$27 CAD 在3天之内
5.0 (21条评论)
4.4
4.4
用户头像
Can empty fields return a result that is simply BLANK? Answer : Yes. Formula = IF(A1="","",YOUR VLOOKUP FORMULA) I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors.I'm looking forward to serve you, on your available task.
$15 CAD 在1天之内
4.7 (43条评论)
4.6
4.6
用户头像
=IF(ISERROR(VLOOKUP(A;B;C));"";VLOOKUP(A;B;C)) I have a better way to do this though: The INDEX function has a better functionality for your needs since VLOOKUP just find the searched value into the first column of the range you input. I have 15 years of experience on this! You can take a look to my portfolio in order to see what I can do for you!
$22 CAD 在3天之内
4.9 (15条评论)
4.1
4.1
用户头像
I am ready with the job .. Lets discuss your job in detail .then pass me a sample work so that i show my work to you. finally we can discuss the payments as well as the milestones.. please don't hesitate to contact me, thank you.
$15 CAD 在3天之内
4.9 (18条评论)
3.8
3.8
用户头像
Hi,,,, if you want to someone help you with VLOOKUP function, i am pretty sure that there is going to be a lot of people that it may help you, BUT if you want someone with a good experience doing automate files in excel,,, I AM THE ONE,,, because sometimes you have to use other functions and know how to use it to improve the task.
$15 CAD 在5天之内
4.8 (13条评论)
3.9
3.9
用户头像
30 years in business computing University Degree in Systems Analysis expert in data manipulation expert in Excel specialise in user friendly solutions accuracy assured available to start immediately
$15 CAD 在3天之内
5.0 (5条评论)
3.8
3.8
用户头像
Hello Dear, I have experience in this project & other task easily and having ability to give back to you fine results. I can do it for good review. Money is no problem. So please just accept me . I am ready to start. Waiting for your reply. Thanks misuxn
$15 CAD 在10天之内
5.0 (6条评论)
2.6
2.6
用户头像
I am passionate about excel and use it daily in my office ( I head a business analysis and planning department of a telecom company). I am not doing projects for just money but, because i love doing such tasks. I am skilled with using lookups through VBA and in excel (Vlookup, index/match are my specialities).
$16 CAD 在5天之内
5.0 (3条评论)
2.3
2.3
用户头像
I am an expert in VBA/Excel/Access and web solutions, with several years of experience in developing VBA/Excel/Access/Web based applications for different business needs. My level of expertise allows me to implement high quality solutions within very affordable budgets. I have a bachelor’s degree in Computer Science and worked for many organizations around the world. Now I am working as a full-time freelancer which makes my mission being strictly to assist people and organizations in creating and implementing solutions for theirs business. Hire me and get professional solutions for your business. At your service,
$15 CAD 在30天之内
5.0 (1条评论)
1.2
1.2
用户头像
Dear Sir/Madam, I like to use excel to perform data entry and data analysis. In my previous working experiences, I used Excel workbooks and joined them together to create a demand planning system. I used a lot of vlookups, pivot tables, advanced formulas, etc... Regarding your question, using the ISNA function can solve your problem. I want to be in your team and do some projects with you. I look forward to hear from you soon. Cheers, Cal
$15 CAD 在10天之内
5.0 (1条评论)
0.8
0.8
用户头像
Dear employer, I can help you with the Vlookup formulas and I am currently available. A: to avoid the N/A, add "=if(isna(vlookup(...);"";vlookup())" to the formulas Have a nice day. Matias
$22 CAD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hey, I'm super proficient in excel. English is also my first language so there will be zero communication problems. I don't have a track record of completed jobs as I'm usually the one doing the hiring :)
$22 CAD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

CANADA的国旗
Stouffville, Canada
5.0
6
付款方式已验证
会员自3月 11, 2015起

客户认证

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