So after two days...
I found this tutorial . It brings the repetitive items.
That is 50%. Basically, there are two lists.
a)a list with no repetitive terms. In the case above.
A
B
b) Then you have a list with all repetitive cells:
A
A
A
B
B
etc.
Need to create the Index() and offset () as described in the tutorial above;
c) Then you have your dropdown cells reflecting "a", NOT 'b':
d) I used =CONCATENATE(cell, cell, etc)
Now you will have something like this
A1street (3 columns, "A:, "1", "street").
Use this to create a table with concatenated terms.
Add your last column (the result needed after choosing 2, 3 etc dropdowns) to the right of the concatenated values.
In my case, ex,
A1street $10,45
d) finally you use the lookup function to match the concatenated terms (as you use the dropdowns) with a specific cell showing the concatenated cells and compare with your new table.
1,2,3
as options in second dropdown. Is that correct? Where doesz,y,w
feature? is that a third dropdown?