I have set of table values. Has two columns "goods" and "prices"
I can create dropdown list based on "goods" then choose "prices" values on a column next to a column with dropdown list.
But I don't want that.
What I want is to choose "prices" values IN the cells with dropdown list that has choices of "goods" values.
Is that possible non vba way?
When I searched about it, results are always about first method. It seems I didn't choose correct keywords on google.