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.

enter image description here

  • 1
    Please provide a link to a sample sheet with a sample of a hard coded output you desire. – CodeCamper Apr 7 '20 at 16:26
  • 1
    Please add a second sheet with desired output. – CodeCamper Apr 8 '20 at 0:26
  • 1
    You should be aware that by choosing to share your spreadsheet, your email address will be unavoidably exposed. – Tedinoz Apr 8 '20 at 1:51
  • Welcome. Please read how to and share a test sheet so as you can be easier helped. – marikamitsos Apr 8 '20 at 17:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.