Vlookup macro based on 2 values returning msgbox

[bd528]

Hi,

Please see attached.

Within File1, I'd like to run a macro which looks at another file (master.xls) for instances for the same invoice (ie : if that invoice has been processed before). The check that needs to be done is if there are instances where the invoice number and invoice amount match.

As per file1 I'd like the invoice number and amount highlighted if there are duplicates on master.xls. A msgbox is also required - showing either "No duplicates found" or "Duplicates found".

Thanks in advance.

[MickG]

Hi, Try this, in "File1.xls".

Please Login or Register  to view this content.

Regards Mick

[bd528]

Absolutely perfect.

Having the duplicate locations in the msgbox is great.

Thank you!