V-Lookup - Combined Lookup Values (2+)

Hey everyone,

I'm trying to use a V-lookup that will combine 2 values as the lookup value instead of just one.

I'm comparing 2 weeks worth of cheques we write out, and seeing which cheques were added between the 2 weeks by using a V-Lookup with the lookup value being an invoice number. This way, whatever invoice numbers do not appear on last week's payments, but do appear on this week's would be a new cheque added.

My problem is, occasionally I'll have the same invoice number but for a different customer. I need to do a V-Lookup that uses both the invoice number AND customer name.

See attached dummy file.

In my dummy file, I would take this as the last 2 invoices were new cheques, however, the first invoice is also new, but is returning the data from another cheque completely due to the same invoice number. I want to make sure it only picks up the 1124 invoice from Walmart, regardless if the invoice number is the same for a different customer.

Thanks!

This is the method I would use to keep it simple. Create a key column in your data that merges your two values to create a searchable set of unique values. Then match to THAT column on your next sheet.