Advanced Drop Down Lists

G

Guest

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
 
G

Guest

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

Guest

Without details I can only advise to use VLOOKUP.

Regards,
Stefi

„bird007†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Excel drop down lists 2
referencing drop down menu values in IF-then statements? 4
Creating and Invoice with multiple dependent dropdown lists 2
Drop Down List 3
Drop down Box / Functions 3
drop down lists and formulas 2
Help With Linking Drop Down Boxes 7
Drop Down lists? 1

Top