I have in Sheet1, column B, 5 types of materials. In column L, I have numbered the position of each one.
So, Position 1 to 6, is 'Plastic tube':
I need a formula, in Sheet2, that can calculate this automatically, so for each type of material to show in what position can be found.
It would be better if can be search by position, because the types of material can be one, 2, or more.