Find Jobs
Hire Freelancers

Excel Macro VBA - assistance with VLookup in VBA

$10-30 USD

キャンセル
投稿日: 5年以上前

$10-30 USD

完了時にお支払い
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running a excel macro. The workbook has 2 sheets Sheet 1 - contains the data that is being corrected Sheet 2 - contains the lookup table with the correct values Ie. Sheet 1 Sheet 2 Sheet 1 Correction Country Look up Correct to U.S.A U.S.A UA USA USA US U.S.A U.S.A US Keep getting the following msg Run-time error '1004' Unable to get the VLookup property of the WorksheetFunction class This is the offending line of code as far as I know NewValue = [login to view URL](LookupValue, LookupRange, 2, False) Timezone is EST Time requirement - on 12/7 or 2/8. The goal is to 1) Get this routine to work properly 2) If possible - have the lookuptable in a separate workbook, instead of the same workbook. Thanks
プロジェクト ID: 18309488

プロジェクトについて

21個の提案
リモートプロジェクト
アクティブ 5年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に21人のフリーランサーが、平均$37 USDで入札しています
ユーザーアバター
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps. Please ping me for more discussion.
$100 USD 1日以内
5.0 (289 レビュー)
7.6
7.6
ユーザーアバター
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
$30 USD 1日以内
5.0 (215 レビュー)
6.9
6.9
ユーザーアバター
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.
$30 USD 1日以内
5.0 (74 レビュー)
5.9
5.9
ユーザーアバター
Hi.. It's probably that the VLookUp is not finding a match and it's throwing that error. Let me check the worksheet to confirm that.
$30 USD 1日以内
4.9 (47 レビュー)
6.0
6.0
ユーザーアバター
Hello, I am Excel and VBA expert. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
$30 USD 3日以内
5.0 (70 レビュー)
5.7
5.7
ユーザーアバター
Hi, I am an expert in excel, VBA, MySQL and power bi. Use excel power query and excel power pivot instead of VBA code. in power query, you can automate replacing, correcting and cleaning the data. and in power pivot, you can look up the values and can create the data model. I am ready to start your project immediately, please let me know more about the project details in chat. Thanks
$25 USD 1日以内
4.8 (48 レビュー)
5.6
5.6
ユーザーアバター
Hello, I am ready to discuss project with you. Being experienced in working on several Excel/VBA/Macro related projects, I can quickly help you in getting it done as per your mentioned details in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$25 USD 2日以内
4.8 (94 レビュー)
5.8
5.8
ユーザーアバター
hi I am an excel-vba Expert and I can help you with your project start the chat to discuss more ......................... ready to start now ....
$35 USD 0日以内
5.0 (38 レビュー)
5.3
5.3
ユーザーアバター
Hello, I am Luis and it will be my pleasure to assist you with your Excel/VBA project. I can realize that maybe will be a better way to do this you are needing because maybe VLOOKUP is not working properly because you have a lot of data or maybe you are missing something in your LOOP/FOR process. Please contact me by chat and then we could discuss further details about your project! Kind regards, Luis Romero
$30 USD 1日以内
4.9 (101 レビュー)
5.3
5.3
ユーザーアバター
Hi, I have read your instruction carefully. I suggest VBA code rather than Formula (VLookup). Because VBA code will provide you lot of things to customize your workbook as per your requirement. While Formula is used to only specific things. I can create macro to lookup specific value on Sheet2 and make correction on sheet1 according to your condition. Macro will give you single click solution and error free result. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$30 USD 1日以内
4.7 (66 レビュー)
5.2
5.2
ユーザーアバター
Hi, I am a professional VBA developer with 8 years of corporate experience. I have excel command on MS Access, MS Excel, MS SQL server database programming and developing. I can fix the issue right now. Please share the excel file or I can join you live to complete the task. Thank you
$50 USD 1日以内
4.9 (9 レビュー)
4.2
4.2
ユーザーアバター
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$20 USD 1日以内
5.0 (13 レビュー)
4.0
4.0
ユーザーアバター
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
$25 USD 1日以内
4.7 (9 レビュー)
3.7
3.7
ユーザーアバター
I am VBA expert, please contact me and share demo file u have. I can check and give advise for you. Thanks.
$25 USD 0日以内
5.0 (11 レビュー)
3.2
3.2
ユーザーアバター
I'm confident to work on this with my similar experience. I'll take full responsibility to complete this work on time & quality. I will update you on the status of work timely until I finish the task. I'm available to start from now. Thanks
$70 USD 2日以内
4.8 (7 レビュー)
3.2
3.2
ユーザーアバター
Hi with over 4 years of experience in Excel VBA, macro I can surely fix this issue within a day or two. I have built several automated models for the clients previously. Let me know in case you are interested, we can discuss this over chat before finalizing. Thanks, Aditya Sarda
$25 USD 1日以内
5.0 (2 レビュー)
2.7
2.7
ユーザーアバター
BETTER IDEA! Using VLOOKUP is not very flexible. I can program a VBA code to search in any data matrix. I already have similar code for flexible searching where you can insert different option in the same search incluiding logical concatenators. ie: Must contain "abc"and "12" + must not contain "z" or "w" etc. I'm an engineer with advanced working knowledge and experience in Excel VBA and VBA interaction between different software (Word, excel, powerpoint, access, autocad etc.). Proficient coder in VB.Net, C#, Python, VB6. I value and honor customer service so I’m responsible for helping, small adjustments, unnoticed corrections or bug fixes even after the project has been paid for and closed.
$30 USD 3日以内
5.0 (2 レビュー)
1.4
1.4
ユーザーアバター
With over 5 years of experience, I am the PERFECT contractor for your project. I specialize in excel, tablue, sql, admin/clerical support, and transcription. My skills include (but not limited to) Microsoft Word, Microsoft Excel, Wordpress, Tablue, VBA and Internet savvy. I am well-rounded, reliable, hardworking, detail-oriented and a quick learner with good communication skills. All tasks are completed in a timely-manner with great efficiency and accuracy. I dedicate myself on providing the highest quality and 100% satisfaction of work
$15 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
-Computer Engineer with 5 years of Excel VBA experience -I can do this within 1-2 hours -Continued free support even after project completion
$10 USD 1日以内
5.0 (1 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Hilliard, United States
0.0
0
お支払い方法確認済み
メンバー登録日:7月 20, 2018

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。