Thread: Invoice Help

Hi - I would like to know if there is a way for me to select a name from a preset dropdown list of suppliers which i can make using Data>Validation function and when I select an individual name then other cells on the worksheet change value in relation to the selection.
So cells change value to display information percific to my selection such as address, supplier number etc...

Thanks
Guy

yes, use a vlook up with the source for look up the cell the data validation

if validation list is in a1 then
look up would be
=VLOOKUP(A1,F1:G3,2,FALSE)
f1:g3 would be replaced with table your data is in
the number 2 is the number of the folumn your retrieved data is in starting counted from from the left most column,eg if your data is in table
E1:k20
COL J WOULD BE 6
the names being looked for must be in the left most column
false means find exact match

ok heres a demo version as requested