Jul 09 2019 08:32 PM
Hi,
I have a large amount of payments which are we are expecting, and the payment received may be slightly different. Is there a way using description and amount to match these receipts and payments, even though they may be slightly different.
Thanks,
Jul 09 2019 09:14 PM
Hello @calof1 , this is hard to answer without a data sample. Can you upload a file with a few rows (please, only a few) and explain what the result should be?
Jul 10 2019 04:53 PM
Thank you for the message.
Luckily i have found a index and match formula which was able to work for most of the data.
Thank you for your time and assistance, much appreciated.
Kind regards,
Jul 18 2019 10:22 PM
I have the attached example where the name is slightly different, but in this case they are a match.
Are you able to help?
Many thanks,
Jul 24 2019 09:55 PM
@calof1 Can you provide a few more examples? And also, what should be matched? Where are the payments?
I this one example, the text in E4 can be found in C4, but are all cases so straightforward?
Jul 30 2019 04:10 PM
Thank you for the reply. I managed to solve this use text function (attached).
Thanks for your time and assistance.