Excel match data
16 USD Source Data
Sheet7
Column A: Ticker
Column B: Date (IPO Date)
Column C needs to be filled: Price
Sheet6
Column A: Ticker
Row 3: Dates (column headers)
Rows below: Prices, where each price is at the intersection of:
the ticker row
the corresponding date column
Task
For each row in Sheet7:
Find the same Ticker in Sheet6 in column A.
Find the same Date in Sheet6 in row 3 (the date format may differ — this needs to be taken into account).
Take the Price located at the intersection of the found ticker and date.
Record the found price in Sheet7 (column C).
If data is not available → output
"Not found".
I tried to do it using chat gpt, but there might be issues with number formatting or something like that in the document. In theory, this task should take 10 minutes. 
Applications 1
Client's review of cooperation with Artem Plakha
Excel match dataExcellent, quality work + project support is very pleasant! Everything was done quickly! Highly recommend!
Freelancer's review of cooperation with Alex Smirnov
Excel match dataI completed an urgent project, grateful for the quick communication and responses to all clarifying questions. I will be happy to collaborate in the future.
-
Winning proposal1 day16 USD
Winning proposal1 day16 USD
Good day. ChatGPT has issues with data types, I understand what you are talking about. I am ready to complete it within the next few hours.
Similar completed project: Розʼєднати великий md файл
-
1 day16 USD
5894 345 0 1 day16 USD
I can fill in the prices on the Sheet7 based on the data from Sheet6...
-
1 day16 USD
4461 102 0 1 day16 USD
Good day. I will be happy to help. I have the necessary experience and skills!
-
1 day22 USD
2870 72 0 1 day22 USD
Hello!
I have been working with formulas since 2008.
My priorities are optimizing calculations and user convenience.
Message me privately, we will do it.
-
1 day16 USD
2428 26 1 1 day16 USD
Hello! Ready to help! Contact me in private messages!
-
Вы открыли кучу одинаковых проектов, в одном уже резервирование есть. Это задумка такая?
Я так понимаю, сложность выросла в 5 раз - раньше писали, что на 2 минуты работы, а теперь уже на 10 ))
-
Alex Smirnov Team Lid
В смысле кучу) Второй проект! Задача осталось прежней, просто прошлый исполнитель не справился за 2 минуты, пришлось дать фору
-
Current freelance projects in the category Databases & SQL
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 3 hours 3 minutes back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 6 hours 35 minutes back ∙ 28 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 15 hours 10 minutes back ∙ 33 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 10 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
602 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 5 days 13 hours back ∙ 56 proposals |
Odessa