ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What function do I use (https://www.excelbanter.com/excel-worksheet-functions/228550-what-function-do-i-use.html)

katiapro93

What function do I use
 
After I combined 2 columns to create 1 column that I can make a drop down
list from can I have the list display my combined data from the combined
column but when selected, can it write in what was originally from only 1
column?

Example:

Helper size Product Price Drop Dwn List:
26oz Jal
26oz Jal 26oz Jal 3.00
26oz Wh
26oz wh 26oz wh 4.00

When selecting from the List: 26oz Wh, it will write in "Wh" only, not 26oz
Wh.


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com