Match Payments which are out slightly in rounding

Regular Contributor



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.





5 Replies

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?

Hi@Ingeborg Hawighorst 


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,

Hi@Ingeborg Hawighorst 


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,


@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?

hi@Ingeborg Hawighorst 


Thank you for the reply. I managed to solve this use text function (attached).


Thanks for your time and assistance.