I don't know if the title reflect the situation but here it is. I have this kind of information (image below) where:
- Column A : 1 serial for 100 cells
- Column B : 10 serials for 100 cells
- Column C : 100 serials for 100 cells
I would like to know if there is a formula so that I can filter a list of cartons and return the corresponding Box and ID with this kind of formatting.