I have prepared an output file template consisting of a full Job list and reference the Invoice Amounts using the following VLOOKUP formula picked up from an earlier topic thanks to Aladin Akyurek. =IF(ISNUMBER(MATCH(A1,INDEX(LTable,0,1),0)),VLOOKUP(A1,LTable,2,0),0) where A1 is a value to lookup in LTable.