How to Use Two Drop-Down Lists in a Conditional IF Field in Word
Question details
The user needs to populate specific content in a Word document based on the selections made in two separate drop-down lists.
- Product
- Word / WPS Writer
- Device & OS
- not provided
- Scenario
- Creating a dynamic form or template that outputs specific text only when two independent drop-down conditions are simultaneously met.
- Observed behavior
- The user needs the target field to display specific text when both drop-down selections match exactly, and remain completely blank if either selection differs.
Ensure your drop-down lists are properly created as form fields and that each has a unique, exact bookmark name assigned in its properties menu.
Use Nested IF Fields with Bookmark References
Use a nested IF formula to check the values of two bookmarked drop-down lists, outputting text only when both conditions are true.
To evaluate two drop-down lists simultaneously, you must nest one IF field inside another. The first IF field evaluates the first drop-down; if true, it triggers the second IF field to evaluate the second drop-down.
Press Ctrl + F9 to insert the first pair of field braces. Inside the braces, type: IF { REF Bookmark1 } = "Selection 1"
Immediately after the first condition, press Ctrl + F9 again to nest the second condition. Type: IF { REF Bookmark2 } = "Selection 1" "Your Target Text" ""
Add empty quotes "" at the end of the first IF statement to ensure the field remains blank if the very first condition is false. The final formula should look exactly like: { IF { REF Bookmark1 } = "Selection 1" { IF { REF Bookmark2 } = "Selection 1" "Target Text" "" } "" }
Right-click the entire field code and select "Update Field" (or select it and press F9) to apply the logic and display the result.
Easily Create Dynamic Forms with WPS Writer
WPS Writer provides robust form controls and field code support, making it simple to build dynamic documents and templates with nested conditional logic.
- 1. Insert form fields: Open your document in WPS Writer and navigate to the Insert or Developer tab to add your drop-down form fields.
- 2. Assign bookmarks: Double-click the drop-down fields to open their properties and assign unique Bookmark names.
- 3. Enter the IF formula: Press Ctrl+F9 to insert field code brackets and type your nested IF logic referencing the bookmarks.
- 4. Update and test: Right-click the inserted code and choose "Update Field" to test your conditional text.
Frequently Asked Questions
Why is my IF field showing the formula code instead of the result?
You may have "Toggle Field Codes" enabled. Right-click the field and select "Toggle Field Codes" or press Alt+F9 on your keyboard to switch between displaying the formula and displaying the actual text result.
Can I add a third drop-down condition to the same field?
Yes, you can continue to nest additional IF fields within the "true" result section of the formula. Ensure you use Ctrl+F9 for every new set of brackets and add the appropriate empty quotes "" for the corresponding "false" conditions.
Why does the field not update immediately after I change the drop-down selection?
Document fields do not always update automatically in real-time. After making a selection in the drop-down lists, you need to select the document text (Ctrl+A) and press F9 to refresh and calculate all field values.
