I am using a vlookup to reconcile invoice amounts. The unique lookup is the invoice number that is located on both spreadsheets. For whatever reason our receivables app doesn’t have the invoice number on some of the line items. For those instances I am just using the date as the unique lookup (on both spreadsheets). Those cases cover about 75% of the spreadsheet.
The other 25% I am having trouble with the vlookup, using date as the unique lookup, because the date invoiced is not the same date we received so the formula is returning #N/A. (1/1/2014 & 1/1/2014 = correct invoice amount; 1/1/2014 & 1/3/2014 = #N/A) Can I add something into my vlookup that says if the invoice was paid within 7 days within the invoice due date to count that value?

Thank you!