Need to check one invoice number in sheet1 is reconciled or present in how many number of times in sheet2

@bobby @Palaniyappan
Need to check one invoice number in sheet1 is reconciled or present in how many number of times in sheet2,if reconciled multiple times ,update status colomn with highest priority status

Various statuses In order
1.posted 2. Under process 3.approved 4.rejected

Use Matches activity

Invoice already have any one status out of 4 status mentioned above need to select highest status from status hierachy

Can you please explain

@bobby @Palaniyappan
Need to check one invoice number in sheet1 is reconciled or present in how many number of times in sheet2,if reconciled multiple times ,update status colomn with highest priority status

Various statuses In order
1.posted 2. Under process 3.approved 4.rejected

Hi, need to send 3 remainder mails for each vendor if invoice is Missing or rejcted,for every remainder mail body and subject will change,and I want to send all remainder mails in single thread mail how can I do it need help