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.
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?
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.
I have the attached example where the name is slightly different, but in this case they are a match.
Are you able to help?
@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?
Thank you for the reply. I managed to solve this use text function (attached).
Thanks for your time and assistance.