multiple columns in drop down list

[Montanes]

Hi all, apologies if this has already been answered elsewhere, there are a lot of threads to search.

In sheet 2, I have 3 columns with 250 stock items. The 1st column has the stock code, the 2nd a description and the 3rd has the pack size.

In sheet 1, I need to select a stock code from a drop down list, but I cant remember all of them so when selecting the code, I want the drop down list to also show the description and pack size in columns 2 and 3 from sheet 2.

The final entry from my drop down list will only show the stock code, I just need the other columns visible whilst selecting.

By the way, I am using Excel 2016 but I need the solution to work in earlier versions at work please.

 

[hicksi]

Where's the dropdown?
On a UserForm, or have you put a dropdown onto a worksheet?
Ie, is it a FormControl or an Activex Control?

If a Form Control, then you need to specify the RowSource.
And you need to know how many lines (rows) contain data

Sheet1!K1:M14

Where K and M are the column bounds, and 14 is the last row of data.
Named Ranges are safer, but more difficult to define

 

[Montanes]

Thanks hicksi, but can you assume you're talking to an idiot with no idea what he's doing...in fact don't just assume please.

Column 'A' in sheet one MUST be restricted to show ONLY a stock code, nothing else. I figured this would be best done by using a drop down list which is easy enough even for me.

I have created the source for this drop down list in sheet 2, using 3 columns as described earlier, stock code, description and pack size.

My problem is that when I am selecting the stock code back in sheet 1 using the drop down list, I cant remember all the codes so I wanted to have the description and pack sizes in display during the selection process.

Once I have selected the correct code, only the code would be in entered in the cell as per a normal drop down list.

UserForm and activex control is foreign to me, sorry.

 

[hicksi]

Thanks hicksi, but can you assume you're talking to an idiot with no idea what he's doing...in fact don't just assume please.

Column 'A' in sheet one MUST be restricted to show ONLY a stock code, nothing else. I figured this would be best done by using a drop down list which is easy enough even for me.

I have created the source for this drop down list in sheet 2, using 3 columns as described earlier, stock code, description and pack size.

My problem is that when I am selecting the stock code back in sheet 1 using the drop down list, I cant remember all the codes so I wanted to have the description and pack sizes in display during the selection process.

Once I have selected the correct code, only the code would be in entered in the cell as per a normal drop down list.

UserForm and activex control is foreign to me, sorry.

Ah... I'll leave this to the Excel-Gurus. I think this stuff (multi-columnar Combo-Boxes) only works with the Activex Control, and I'm not even sure that it works on the Embedded one on a Worksheet.
Sowwy.