En cours

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.

Compétences : Excel

Concernant le client :
( 3 commentaires ) Paris, France

Nº du projet : #25768925

Décerné à:

xcelinfinity

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(6 Commentaires)
4.0

37 freelances font une offre moyenne de 16 € pour ce travail

cgullapalli

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(963 Commentaires)
8.1
P0L

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(449 Commentaires)
7.8
TonmoyRoy111

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(432 Commentaires)
7.3
daniyal3214

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(108 Commentaires)
6.2
writingapp

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(78 Commentaires)
5.7
zaahidali61

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(18 Commentaires)
4.6
shish1992

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(7 Commentaires)
3.7
Mainaah

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, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(4 Commentaires)
1.8
Hasor97

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(2 Commentaires)
0.6
triptisam1993

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(1 Évaluation)
0.4
chcharan422

Hi, Greetings I have read your project placements and it matches with my expertise. I understand you are looking for a data entry expert. Who can convert pdf into word file with high accuracy. I'm a data entry exper Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(0 Commentaires)
0.0
balajikhare96

Dear Prospective Client Ready to START now with a sample for the accuracy and quality check. I will perform an accurate web search to collect the required details by following all your directions and instructions and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
Innokia

I can handle this project with confidence, hope you will grant this project to me, So you won`t worry about this as I will do this to you in a given time frame & low budget.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
dwivedidharmendr

I will do this work Relevant Skills and Experience I have experience i will do.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
KHAN11519

i have five year experience relates your project please share with me your project detail i will send you after completion as soon as possible

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
Iccgaggoo

Yes i am full command on MS Excel work sheet. Excel Formulla easily apply for this sheet. I am ready to continue Excel work.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
Bisworanjanpradh

Hello, I'm highly interested in this project.I did same types of project [login to view URL] don’t be fell hesitate to invite me.I am expert in data entry, web search, web scraping, excel, copy typing [login to view URL] check my pro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(0 Commentaires)
0.0
Ravishukla9599

I HAVE VAST EXPERIENCE IN THIS SO PLZ GIVE THIS PROJECT TO ME Relevant Skills and Experience EXCEL DATA ENTRY WORKED WITH TNT FEDEX DUE TO COVID 19 I HAVE LOST MY JOB

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
aimes2win

Needs can complete work on time Relevant Skills and Experience Gud skill way to work

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
ash58027370de646

I can do this task for you, I'm a professional Microsoft office expert with 6 years of experience. I'll sort your problem and I'm sure you'll be pleased with my work.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0