Extracting Data from a secondary worksheet if the vendor and invoice match

[leighnea]

I have two worksheets. Worksheet 1 is the Detail AP Listing which has the vendor #, Invoice number and the description of what the invoice is for. Worksheet 2 is the GL which has the vendor # and the invoice number but not the description. I need to populate the Description of the invoice in the GL. THERE ARE DUPLICATE INVOICE NUMBERS so the Vlookup doesn't work.

 

[leighnea]

IT WORKS!!! Now the next problem is "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." It eventually does calculate everything it just takes a while. I am worried that as the month goes and the report grows it won't make it. Is there any other way to do this without an INDEX Match & Match formula?