Drop Down Box with value being returned in a cell below

[nick_w]

Hello

I wonder if anyone can help me

I am creating a sheet where I have a drop down box with a list of different products in and I want a value in a cell below to be entered depending on what is selected in the drop down box

My drop down box is in

B8

It has a list of 8 items in (list is contained in the next sheet)

I want a letter to be entered in the box below depending on what product is selected. Each product has a unique letter

Could somebody help me with this please, and then I can apply it to the remaining items in my product coding sheet

Thank you all very much

Nick

[jeffreybrown]

Hi Nick & Welcome to the Board,

In the column next to each of the 8 items in the list, place the unique letter and then in the cells where you want the letter to appear use a Vlookup...

http://www.contextures.com/xlfunctions02.html