Advanced Drop Down Lists

B

bird007

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
 
P

paul

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).
 
S

Stefi

Without details I can only advise to use VLOOKUP.

Regards,
Stefi

„bird007†ezt írta:
 
Top