View Single Post
  #1  
Old April 22nd, 2009, 07:40 PM posted to microsoft.public.excel.worksheet.functions
katiapro93
external usenet poster
 
Posts: 5
Default 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.