Advanced Drop Down Lists
 

Hi there,

I would like data to be automatically inputted into cells once i select data
from my drop down list i have created.
Eg I select a product sold to a customer and would like the cost price, sale
price, tax and total sale price to pop up in their consectutive cells along
the row.

Any help would be greatly appreciated.

Thanks

Advanced Drop Down Lists
 

thats easy
you obviously already have a "table" with all the relevant data.You need to
use vlookup across several columns to return the data you want.
your vlookup will look like
=vlookup(customer name,table range,col no of data wanted,false).
--
paul

remove nospam for email addy!



"bird007" wrote:

Hi there,

I would like data to be automatically inputted into cells once i select data
from my drop down list i have created.
Eg I select a product sold to a customer and would like the cost price, sale
price, tax and total sale price to pop up in their consectutive cells along
the row.

Any help would be greatly appreciated.

Thanks

Advanced Drop Down Lists
 

Without details I can only advise to use VLOOKUP.

Regards,
Stefi

€žbird007€� ezt Ã*rta:

Hi there,

I would like data to be automatically inputted into cells once i select data
from my drop down list i have created.
Eg I select a product sold to a customer and would like the cost price, sale
price, tax and total sale price to pop up in their consectutive cells along
the row.

Any help would be greatly appreciated.

Thanks