0

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':

enter image description here

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.

Like this:

enter image description here

or

enter image description here

It would be better if can be search by position, because the types of material can be one, 2, or more.

Link: https://docs.google.com/spreadsheets/d/1CDdvFChCx2_1bZ3rY2ZApQOjOM22rTcLx4mUllNqYqw/edit?usp=sharing

Improve this question
2
  • 1
    What is the difference between Plastic tube in 1,2,3,4,5,6 and Plastic tube in 15,16,17?
    – marikamitsos
    Feb 19, 2021 at 14:30
  • Welcome to Web Applications. Please show what you tried and add a brief description of your search efforts as is suggested in How to Ask.
    – Rubén ♦
    Feb 19, 2021 at 18:49

1 Answer 1

Reset to default
0

'What is the difference between Plastic tube in 1,2,3,4,5,6 and Plastic tube in 15,16,17" - there is no difference. Just to show what kind of material is in each position. I tried with IFERROR but not working as I want to.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.