Change column data based on drop down selection

[jeremy9400]

Hi, i am new to excel, so if anyone can please help me out i would really appreciate, i have a lot of items in a few different styles, and i want to make a price list in a way that when the customer will select the style from the drop down list, he should automatically get the price next to the item name column, what would be the best way to work this out?

[JBeaucaire]

Create a reference sheet with your items listed in column A, your prices in column B.

Then on your main sheet enter an item in a cell, then in the cell next to it use a VLOOKUP() formula to pull in the price from the reference sheet.

Press the F1 key in Excel al read in the help files how to setup your VLOOKUP.

[jeremy9400]

Thank you so much for helping me, the thing is that I wanna have the list of items in the first column, the item names doesn't change, only the styles are different, so what I want it'd that if I select one style, column B should automatically change with that price list and if I change to a different style column B should change to that styles price list
Thanks again

[JBeaucaire]

VLOOKUP is the correct choice based on your descriptions so far. It is specifically for pulling information from a table matching a key piece of information, like your item name.

[jeremy9400]

can you show me how? thanks
https://mail.google.com/mail/u/0/?ui...f_i2xhk9ig0&zw

[JBeaucaire]

Attach a sample workbook. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[jeremy9400]

is this good?

[JBeaucaire]

In C4: =HLOOKUP(Style, $O$3:$U$8, 2, 0)
In C5: =HLOOKUP(Style, $O$3:$U$8, 3, 0)
Etc...

[jeremy9400]

thank you so much it works perfect can you please explain whats happening?

[jeremy9400]

also what can i do to copy the formula on the entire column?

[JBeaucaire]

Press F1 and read in the help files the tutorial on HLOOKUP and VLOOKUP. It explains it fully with examples better than I would off the cuff.

You could change the 2 in the first formula to ROW(A2), then when you copy the cell down it would adjust itself.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.