I have an excel datatable which contains 20 codes: 01 until 20. The value in the cell is stored as variable “Code”
Then, I have to enter this “code” on a webpage with a dropdownbox.
I found a way by nesting 20 if functions, but I bet there should be an easier way.
For example, if Code = 01 then select item “01. Location outside of EU”.
Thanks in advance,