What formula did you use to return the customer? =VLOOKUP(A8,A1:C4,2,FALSE)
What formula did you use to return the Invoice value? =VLOOKUP(A8,A1:C4,3,FALSE)
What would happen your formula if you entered a new column of data between the invoice number and the Customer in the lookup table? The value returned for Customer is unaffected, but the value returned for Invoice Value changes to 0. The formula would have to be updated to reflect the change in the table array and column index number.