I need help to get the number of specific item from a list.
Dropdown 1: select a field from list of each item in first Colomn A
Es: i choose A2
Dropdown 2: I would like to search from list of item in colomn B and row selected in dropdown 1.
Es: I would like to choose one of item between rowA2.1 ecc.
Then, I need to know the number of item choosed in dropdown 2
ex. If i choose rowA2.2 (item#2) the number would be: 2
And i want to show this number in the input field
With this number I can get the same number of item (es. item#2) of each colomn, isn’t it?