How to change column data based on drop down selection

[jeremy9400]

hi, i am new to excel, and i need some help, in our company we have a lot of items in seven different styles, and i want to make a sales order on excel, where in column A the customer will have a list of the items, and once he selects the style from the drop down, he should automatically get the price list for that style in column B

 

[Marcílio_Lobão]

jeremy9400, Good morning.

The VLOOKUP function is the ideal Excel tool for this situation.

For more information, attach an example of your file with data and the desired result.
To attach files here use an ADVANCED OPTION when answering post.

Is this what you want?
I hope it helps.

 

[jeremy9400]

Take a look at this
https://mail.google.com/mail/u/0/?ui=2&ik=071810a642&view=att&th=149e7d00036e4eef&attid=0.1&disp=safe&realattid=f_i2xhk9ig0&zw

 

[Marcílio_Lobão]

jeremy9400, Good evening.

Sorry, but your link doesn't work for me.
Could you save it at a free site, WWW.SpeedyShare.COM, and put a link to download here?