Find Jobs
Hire Freelancers

Excel VBA VLookup - Running too slow

$30-250 USD

Anulat
Data postării: peste 5 ani în urmă

$30-250 USD

Plata la predare
I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [login to view URL](LookupValue, LookupRange, 2, False) This from an example - that I can’t get it to work: ' =IF(VLOOKUP(lookup_value, table_array, 1, TRUE)=lookup_value, ' VLOOKUP(lookup_value, table_array, col_index_num, TRUE),NA()) This gig is to get an existing routine running faster I know what this line is running slow, I don't know what the fix is. The trick question is - do you know why this line of code is slow? If you do, then I know you understand the problem, and hopefully the fix, and I'll know you actually read this msg. I will provide the macro code upon project aware Thank you
ID-ul proiectului: 18349353

Despre proiect

28 propuneri
Proiect la distanță
Activ: 5 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
28 freelanceri plasează o ofertă medie de $97 USD pentru proiect
Avatarul utilizatorului
Hello, Hope you are doing well. I can help with you in your project Excel VBA VLookup. I can assure you the quality job. I have good experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps . We have worked on several similar projects before! We have worked on 425+ Projects. 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. Thanks,
$160 USD în 3 zile
4,9 (525 recenzii)
8,4
8,4
Avatarul utilizatorului
I am proficient with Microsoft excel and macro/VBA development, I understand the reason why it takes long time to perform VLOOKUP as depicted in your description and most likely I have the solution to fix it. Would be great if you can provide a copy of your current workbook so I can give you a confirmed answer. If you are interested feel free to message me, I am available to start your project immediately. Looking forward to chat further and work on your project.
$100 USD în 3 zile
5,0 (155 recenzii)
7,5
7,5
Avatarul utilizatorului
Hello, As an expert in this topic, i am very much interested to work on it to make the VLOOKUP faster, you are right double vlookup can make it faster, but it also depends on few things. I believe i can make it faster. Looking forward to have a positive response from you. Thanks
$50 USD în 0 zi
5,0 (243 recenzii)
7,6
7,6
Avatarul utilizatorului
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
$100 USD în 1 zi
5,0 (335 recenzii)
7,4
7,4
Avatarul utilizatorului
I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform data analysis, data base modeling, process optimization and automation. I will be happy to discuss in detail how I am highly suitable for this project
$100 USD în 1 zi
4,8 (174 recenzii)
7,1
7,1
Avatarul utilizatorului
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. Will rewrite the code a bit to make it work faster. Willing to take up your project. Thank you, Regards.
$100 USD în 1 zi
5,0 (181 recenzii)
6,9
6,9
Avatarul utilizatorului
I have read your project description and it seems that the problem is that the actual size of your data. Using Vlookup checks your whole data which why it takes more processing time. I have an alternative solution which involves using a loop; feel free to contact me so we can discuss more.
$50 USD în 2 zile
4,9 (233 recenzii)
7,1
7,1
Avatarul utilizatorului
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
$45 USD în 3 zile
4,9 (276 recenzii)
7,0
7,0
Avatarul utilizatorului
Hello? How are you? I have good experiences in "Excel VBA VLookup - Running too slow" as you can see my profile for these (Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$155 USD în 3 zile
4,8 (99 recenzii)
6,7
6,7
Avatarul utilizatorului
Hi I know how to fix your vlookup vba issue and speed up the process I am from NYC, NY, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Expert in PYTHON,.NET, VB, VBA, MYSQL, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Large scale application development, Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, etc., Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to hear from you soon. Have a great day. Thank you.
$45 USD în 1 zi
4,8 (89 recenzii)
6,2
6,2
Avatarul utilizatorului
Hello, I am Excel and VBA expert. The problem is not the line of code you are writing about. The whole macro is a problem. You can not change one line of code to make the macro fast. The entire macro must be written so that it is fast. I can write this macro anew and I guarantee it will be much faster. How big is the sheet, how many rows? 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
$150 USD în 3 zile
5,0 (98 recenzii)
6,2
6,2
Avatarul utilizatorului
I will write a customised VBA Function that will conduct a fast lookup of the required range...Please confirm how long the current process takes to produce an outcome.
$155 USD în 3 zile
5,0 (43 recenzii)
6,1
6,1
Avatarul utilizatorului
Hello, I am ready to discuss project with you. Being experienced in working on several excel vba projects I can help you in getting vlookup fix done. As line given by you there are 2 nested vlookups happening which seems to causing it slow because of huge data. A workaround seems to be used through some vba code to make it work faster. 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
$83 USD în 1 zi
4,8 (128 recenzii)
6,1
6,1
Avatarul utilizatorului
Hello, I would be my pleasure to help you out in improving the speed of the macro. There could be many reasons why the lookup is slow. First of all, VLOOKUP is slower than INDEX-MATCH. I would use the second one instead It's possible to use double vlookup with approximate match that is using binary search and it's faster. At the same time, could be other issues on why the lookup is slow. For example the screenupdating and calculations are not turned off Kind regards, Sorin
$30 USD în 0 zi
5,0 (74 recenzii)
5,6
5,6
Avatarul utilizatorului
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
$100 USD în 3 zile
5,0 (46 recenzii)
5,2
5,2
Avatarul utilizatorului
Hi there, First of all NA() is not a function. Second, the using VLOOKUP in VBA is always slower than using loops and arrays. I can help you out and make sure your code is optimised to run at the highest speed possible for Excel. PM me if interested
$111 USD în 3 zile
4,8 (24 recenzii)
5,0
5,0
Avatarul utilizatorului
Hello, Hope you are doing well. I have gone through the project requirement of improving the Vlookup performance and find my self in good position to complete this project using alternative option other than Vlookup to get you faster results. I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay
$50 USD în 1 zi
5,0 (13 recenzii)
4,0
4,0
Avatarul utilizatorului
Hi, there must be many other cells with formulas, that are being calculated each time this line of code puts a vlookup formula in the cell. You see, all the formulas re-calculate on each sheet_Change event by itself. I can provide a great solution for this, and very quickly. Please initiate a chat. Regards, Anish
$55 USD în 1 zi
5,0 (3 recenzii)
3,3
3,3
Avatarul utilizatorului
Good day, my name is William Pinder. I am an Excel Specialist with 10 years of professional experience. I currently work as a 'Data Administrator' and I also offer freelance Excel services. I have read your project description and I am highly confident I can speed up your macro. It is also possible that I can design an improved macro/process. I have recently worked on a few macro based projects. These include: -An inventory tracker -A shipping cost calculator (using fuel prices from a website) -A dashboard designed to work like a website I am available to begin work now and I will finish the project today.
$150 USD în 1 zi
5,0 (3 recenzii)
2,6
2,6
Avatarul utilizatorului
Hi, Just read you description I have done few excel and formula's projects on freelancer as well and also have a knowledge of python which works very fast in your case of problem. Work at a reputable IT firm in my county called TCS. I will accept and start working right now. Ask on chat if you have any doubts
$55 USD în 1 zi
4,9 (6 recenzii)
2,7
2,7

Despre client

Steagul UNITED STATES
Hilliard, United States
0,0
0
Metoda de plată a fost confirmată
Membru din iul. 20, 2018

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.