How to update rows based on the comparison of 2 excel files and additional conditions?


I have the following files:




This is what I’m trying to accomplish:

  1. If the column “A” of the file Invoices.xlsm (sheet “FormatedforUpload)” is = to 25,
  2. then compare column D with the file Terms.xlsx (sheet “Raw Data”) column “Supplier ID
  3. If both columns match, then copy the data that is between () of column “Payment Term” to column F into the file Invoices.xlsm (sheet “FormatedforUpload”)

Expected Result:

How can I do that?

This is what I have so far… (83.1 KB)

Any help you can give would be greatly appreciated! :slight_smile: :pray: (52.8 KB)

1 Like

It works! Thank you very much! :grinning_face_with_smiling_eyes:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.