You should have a table of supplier names and payment term for each, then using VLOOKUP to get payment term. Anyway, upload an example spreadsheet please.