如何用Excel的CHOOSE函数实现文本与单元格值的拆分显示

Got it, let's work through this to get that split output you want—just like how Python prints multiple values side by side. Here's a straightforward, no-macro solution that plays nice with your existing Form Control setup:

Step 1: Confirm your option button link #

First, make sure your 3 Form Control option buttons are still linked to cell $K1 (since your original formula relies on this). Each button should return a unique number when selected:

• Foo → 1
• Bar → 2
• Baz → 3
  This is usually set automatically when you group the buttons and link them to a cell, but a quick double-check won't hurt!

Step 2: Set up the two adjacent cells #

Let’s say you want the descriptive text in cell D2 and the actual value from C2 in cell E2. Use these formulas:

For the label cell (D2): #

Enter this formula to show the fixed label when Foo is selected, or your original static text for Bar/Baz:

=IF($K1=1,"value of C2 is ",CHOOSE($K1,"","baa","bee"))

• When Foo is selected ($K1=1): Displays "value of C2 is "
• When Bar is selected ($K1=2): Displays "baa"
• When Baz is selected ($K1=3): Displays "bee"

For the value cell (E2): #

Enter this formula to show C2's value only when Foo is active, and stay blank otherwise:

=IF($K1=1,C2,"")

• Foo selected: Shows the real-time value from C2 right next to the label
• Bar/Baz selected: Leaves E2 empty, so your static text in D2 looks just like your original setup

Step 3: Test it out #

Click through each option button to verify:

• Foo: D2 shows the label, E2 shows C2's value (exactly that split effect you wanted!)
• Bar: D2 shows "baa", E2 is empty
• Baz: D2 shows "bee", E2 is empty

If you wanted the Bar/Baz text to span both cells, you’d need VBA to merge/unmerge cells dynamically—but the formula approach above is simple, macro-free, and keeps everything lightweight.

内容的提问来源于stack exchange，提问作者motiur