Use VLOOKUP().

See Excel Help
--
Gary''s Student - gsnu200795


"Adrian Bamford" wrote:

Hi, I am setting up a workbook to handle the payment of invoices that I get
from various suppliers.

On one sheet (within the same workbook) I have set up details of supplier
name, account number, settlement discount etc.

On the main sheet, you can choose supplier for a particular invoice from a
drop-down list referencing the 'supplier' sheet, but is it then possible, on
choosing the supplier, to autofill adjacent cells on the main sheet with the
other info?

Hope that makes sense.

Adrian