Matching a information from a cell and selecting in from a drop down

Another option is to use SimulateClick on the item in the dropdown after expanding the menu. So you click once to open the drop-down, then SimulateClick to choose the item. You’ll need a dynamic selector for the 2nd one where you insert the value from Excel into an attribute containing the name of the choice.

1 Like