Drop down lists and autofill

[Adrian Bamford]

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

 

[Gary''s Student]

Use VLOOKUP().

See Excel Help

 

[FC]

=VLOOKUP(A1,SHEET2!$A25:E700,COLUMNS($A:B),0)
This formula assumes this :
A1> is where you have your dropdownlist (adjust as needed)
SHEET2!A25$:E700>data place in sheet 2(or any name you want)between A25 and
E700 ( again adjust as needed).
COLUMNS($A:B),)0 >the only variable will be "B" and that's the cell you are
going to put the formula to VLOOKUP in the original working sheet. Then
change it to "C"
when you put the same formula in C in the original working sheet, ETC. and
copy down. Post back if any questions.

 

[Debra Dalgleish]

As others have suggested, you can use a VLOOKUP formula to pull the
supplier data. There's an example order form here that might help you:

http://www.contextures.com/xlOrderForm01.html