Hi please need a help.
I have a excel sheet as given below. I need to make a drop down list of that, when I select item name from the dropdown list , item code also come in the next column. Is it possible .
Sheet1
<thead>
</thead><tbody>
</tbody>Excel 2007
I have a excel sheet as given below. I need to make a drop down list of that, when I select item name from the dropdown list , item code also come in the next column. Is it possible .
Sheet1
A | B | |
---|---|---|
1 | Item Name | Code |
2 | TRIM CLIP ON LED PANEL 6W 6500K | LHEAABP7IL1W006 |
3 | TRIM CLIP ON LED PANEL 12W 6500K | LHEAABP7IL1W012 |
4 | TRIM CLIP ON LED PANEL 18W 6500K | LHEAABP7IL1W018 |
5 | LED ADORE 10W B22 CDL 3STAR LAMP | LHLDEUEEML8R010 |
6 | LED ADORE 9W B22 CDL 3 STAR LAMP | LHLDEUEEML8R009 |
7 | TRIM CLIP ON PANEL 24W 6500K | LHEAABP7IL1W024 |
8 | TRIM CLIP ON LED PANEL 6 W 4000K | LHEAABP6IL1W006 |
<thead>
</thead><tbody>
</tbody>
Last edited: