Good Day,

I am working with a workbook trying to marry payment amounts with invoices from two separate spreadsheets. Criteria for the current look up is the customer, invoice amount, and document type (invoice vs credit). The issue I am having is marrying invoices with payments that me be off a couple of cents (+/-) due to rounding. Below is what I'm currently working with, but I am at a lost beyond this. Thank you.

INDEX(altref,MATCH(1,(rtype="Invoice")*(amount=$K143)*(customer=$C143),0))

altref = invoice value I want retruned
rtype = document is invoice vs credit

Example

Spreadsheet 1 Customer 1 invoice 21-12345-01 amount 12.33

Spreadsheet 2 Customer 1 payment 12.34 Invoice N/A with above formula
Should still return value 21-12345-01