What function do I use

K

katiapro93

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using V or H lookup 3
Copy down 0
Drop down list control value in vba 2
Need help referencing b/w sheets for school project 0
Excel does not accept text format! 0
E-mail backup to .pst file 0
How can I improve my query? 2
Help! Is this possible 2

Top