Match Payments which are out slightly in rounding

Iron Contributor

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,

 

 

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.