Hello,
I have set up a sheet in which a form will submitted with 4 columns; a specific label (from a dropdown list), and then up to three barcodes. On the grid I also have a hidden created date column.
I am then wanting to create a separate sheet that collates the most recent barcode for each column for label for the day. Normally, I would do this with individual references of each column and then use a standard index/collect, however I anticipate the number of columns to grow, so I would ideally like to use a large reference instead. I am used to using a header row and a match function to determine which column I'm looking for while using vlookup, however I can't seem to find a way to utilize that in this case.
Hopefully that makes sense, I can provide a screenshot if I was unclear.
Thank you!
