Small function on Excel

I just need to retrieve values from one table to another on the same excel file.

This table is a list of clients to be dunned. The first table "2018" is the list of customers in 2018, and table "2019" is the list of customers to be dunned in 2019. What I want to do is to retrieve the comments from table 2018 to put them back in table 2019. Between table 2018 and 2019 there may be customers who no longer exist because they have regularized their situation, and new customers may appear because they are late in paying. Retrieving comments from one year to the next is just to retrieve the history of customer comments that are still present from one year to the next. The formula shown in cell G2 of table 2019 is a formula that should normally be the correct solution, but I don't understand why it doesn't work.

So I need either the formula to be corrected or I need a solution that would allow me to get the desired result.

Taidot: Excel

Näytä lisää: small reporting excel, yield function excel java, free examples finance function excel vba cost price, excel large function, iferror small excel, excel small function for text, excel small function ignore zero, excel small function ties, excel index function, row function excel, index small excel, function excel, small basic excel, formula function excel, implementing irr function excel, estimation function excel, call function excel sheets cell click, php function excel report, ipv function excel, irr function excel increase iterations

Tietoa työnantajasta:
( 2 arvostelua ) Paris, France

Projektin tunnus: #25768925

Myönnetty käyttäjälle:


Hi there My name's Benne and I have helped thousands of people via Excel forums, training, and consultancy projects. i have done it for you. can also explain why yours didn't work

€8 EUR 1 päivässä
(5 Arvostelua)

38 freelanceria on tarjonnut keskimäärin €16 tähän työhön


HI, I am good at Excel and formulas. I have referred the requirement. I can pull the value from one sheet to other. -Chandra

€8 EUR 1 päivässä
(923 arvostelua)

Hello, I can help you with your function. I have over 10 years of experience in Excel and VBA code. Let me know if you would like to discuss further.

€30 EUR 1 päivässä
(407 arvostelua)

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

€15 EUR 1 päivässä
(425 arvostelua)

I can definitely help you with that. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro). I will be happy to discuss in detail Lisää

€19 EUR 1 päivässä
(78 arvostelua)

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

€10 EUR 1 päivässä
(50 arvostelua)

Hi, I have gone through your attachment I can retrieve from one table to another as per your instruction. I am excel expert having 10+ years experience. I have completed similar project for different employers. Looki Lisää

€10 EUR 1 päivässä
(17 arvostelua)

Hi, I have a lot of experience working with excel formulas. I have already worked on the formula using vlookup in your document. Please give me an opportunity so I could provide a solution.

€15 EUR 1 päivässä
(13 arvostelua)

Hello there.. , I'm a Data Scientist and mathematician. I am well versed with:  Algebra and analysis. I work on: Linear algebra  Statistics - Statistical modeling using R -Markdown report  Marching Learning usin Lisää

€30 EUR 7 päivässä
(5 arvostelua)

Dear Prospective Client, I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, Countif, SUMIF, Left, Right, Index Match, Drop Down, Filters, Charts, Graphs, Conditional Formatting, Lisää

€10 EUR 1 päivässä
(3 arvostelua)

Hi,there. I read your project very well andI am highly interested to work this project. I will provide very [login to view URL] details visit my profile and contact me.I am available to start the project now. thanks

€14 EUR 2 päivässä
(2 arvostelua)

I can solve your issue to consolidate both the excel into a final excel file as per your requirement. I am an engineer having expertise in excel. Please message me to discuss in chat.

€20 EUR 3 päivässä
(1 arvostelu)

i can do help you in your work i am doing a freelance work i will do complete your work excel set as you say i am also doing work

€19 EUR 7 päivässä
(0 arvostelua)

Hello and Welcome to my profile. Let me introduce myself. I am Rahul, Data entry, logo design professional. I'm self-motivated and hardworking individual. I believe in customer satisfaction, quality work and I'll compl Lisää

€12 EUR 2 päivässä
(0 arvostelua)

I think I am very good at Microsoft Office tools, so I can do this stuff very properly without any mistakes.

€8 EUR 1 päivässä
(0 arvostelua)

My name is Dei Aqidah. I am a fresh graduate from Jember University, majoring in agricultural social economics. During the study period, many courses require to process data using Microsoft Excel, such as feasibility Lisää

€8 EUR 7 päivässä
(0 arvostelua)

Hello sir, I think I'm suitable for this project since I've been working on Excel processing in my PhD .Therefore, I reached an advanced level in handling Excel [login to view URL] you send me your excel file, I will figure out Lisää

€16 EUR 3 päivässä
(0 arvostelua)

I consider my self a fast typer very good translator and i have excellent experience in excel and word files Also i am available 24/7 for any updates

€12 EUR 2 päivässä
(0 arvostelua)

I am very enthusiastic about my work . always ready for new challenges. People consider me to be a social, temperamental person who doesn't annoyed with work . I have sound knowledge of this kind of work and i am despe Lisää

€10 EUR 6 päivässä
(0 arvostelua)

Hi I have good knowledge in Excel Formulas and I having 21+ experience of giving reports to our clients.. Kindly connect me on Email will sort out your problem Regards Paresh Shah

€15 EUR 2 päivässä
(0 arvostelua)

Hi There, I have good knowledges in excel and formula. I can help you to solve the problem. Warms Regards, Rahmad

€10 EUR 7 päivässä
(0 arvostelua)