vlookup formula need to set it up to find the date with the most recent update

[pmiguel]

Hello!

I have this workbook that I need help with. Workbook contains 2 tabs on the second tab I have listed all the error files and the measures taken to correct those errors. On the first tab I have a running list of all the invoices which at times will show the same invoice # more than once. On the column for the status I currently have a VLOOKUP formula to lookup on 2nd tab the matching invoice # and populate the original error message, date and the corrections that were done. The issue is that when that invoice get resubmitted the formula is picking up the error message again even though it got accepted.

I need to tweak the formula so that it looks up the invoice # but return the error message only when there is an error. If the invoice number contains an error the second time I need it to pick up the second error message and not the first one. Does that make sense? Here's the formula: =IFERROR(VLOOKUP(B82,'Payor Rejected Detail'!$B$1:$D$3538,3,FALSE),"")

I have attached the workbook so it can be viewed. Can someone please help?