Quick Excel fix - expert help replace my TEXTJOIN nightmare

In have a workbook with just 2 tabs. on tab 1 i have a long list (300K rows) and on tab 2 I have a long list (150K rows). I need to lookup the values in column A on tab 2 against column A in tab 1 and then show the value in column B but i have cases where i have more than 1 match in column A and i need to see all of the matches together on tab 2. so I have this formula which works 100% perfect


but... its slow and basically everytime i touch the sheet it locks up. I think there is a smarter way to handle with this index or maybe a smart vlookup but I know for sure this textjoin i have now isnt going to work. the reason I choose it was that if i have more than 1 match it nicely combined the values in to a single cell as seen here [login to view URL] but the workbook is not usable at this scale with this formula.

Need some quick help on this and ideally we can just replace what we have with your new formula and keep going on our way. the final output needs to be sure to handle these cases

no matches against tab 1, 1 match against tab 1, many matches against tab 1

Like answer here is something like pre sorting tab 1 and using OFFSET and INDEX and AGGREGATION

here is a sample sheet so you can see what i mean about the performance of this. I have chatted with several people about their ideas and I need to say for sure a solution here is not waiting 10 minutes for it to update and then copying static values.

[login to view URL]

Habilidades: Excel, Processamento de dados, Processamento de Dados, Visual Basic, Microsoft Office

Acerca do Empregador:
( 456 comentários ) Austin, United States

ID do Projeto: #21784444

42 freelancers estão ofertando em média $33/hora para esse trabalho


Hello there, Let me handle your requirement. Hope I can do a quality work for you Waiting for your good reply Amaan

$30 USD / hora
(70 Comentários)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Mais

$40 USD / hora
(344 Comentários)

Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.

$35 USD / hora
(330 Comentários)

Hi, I am expert Excel, and /VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database, especially with importing external files to a structured database in Excel and Mais

$38 USD / hora
(84 Comentários)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Mais

$25 USD / hora
(235 Comentários)

Hi, I have checked the project description and I will build a Excel VBA macro for this purpose instead of use of functions, that will be faster and efficient. I am a full time freelancer and can work dedicated on this Mais

$25 USD / hora
(87 Comentários)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Mais

$25 USD / hora
(122 Comentários)

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your pr Mais

$25 USD / hora
(72 Comentários)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not Mais

$41 USD / hora
(36 Comentários)

Hello! I understood your project. I see that you need some help for fixing excel data processing issue. I am on freelancer all day and I will implement all things that you want perfectly. I can help with that and can s Mais

$45 USD / hora
(2 Comentários)

Hello, i can write VBA code to do the textjoin work , it will be faster samples of my VBA work : https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/exc Mais

$25 USD / hora
(52 Comentários)

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Mais

$25 USD / hora
(19 Comentários)

I can do it in 3~4 hours Hi, I am a senior windows developer. I have rich experience with excel and vba programming. I can do it perfectly. Thanks

$25 USD / hora
(4 Comentários)

Hello, I can help you with your project, can you send me a message to discuss more details of the file attached?, I can start working on the best solution immediately.

$40 USD / hora
(26 Comentários)

Hi there, You have a very huge data set amounting to almost half a million rows. I used to handle data set that was a third of size of yours and encountered same issue. I learned that having arrays formulas nested in Mais

$40 USD / hora
(2 Comentários)

Hi, Vlookup function is one of the most heaviest functions in Excel, so when you use it for a large data (like 300K) and you use it with other formulas (like textjoin) then your Excel will took time to process. There i Mais

$25 USD / hora
(7 Comentários)

Hello,sir. I have read your post and noticed that you were looking for someone who can do your job - 'Quick Excel fix - expert help replace my TEXTJOIN nightmare' I can show you my work history, if you want. I am a p Mais

$41 USD / hora
(1 Comentário)

Hi there, I am an experienced developer and after reading your project description, I am confident that I am a suitable candidate for this project because I have 3+ years of experience in excel, data-entry, copy-typin Mais

$25 USD / hora
(2 Comentários)

Hi , I am an MBA professional having 4yrs of experience in Analytics, Tableau, Advanced Excel, VBA and Python. I have done ample amount of work in excel and VBA and I could show some examples of it. I can give you a sm Mais

$25 USD / hora
(4 Comentários)

Hi, I can get you the static values you need in about one minute. (copy paste and excel processing) It will require 2 helper columns in Tab 1. Is that OK? regards Reuben

$25 USD / hora
(2 Comentários)