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.
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
38 freelanceria on tarjonnut keskimäärin €16 tähän työhön
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
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.
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
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.
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