vendredi 28 février 2020

Creating a list of CheckBoxed items across multiple google sheets

I'm struggling to find the right formula to do a relatively simple task. I have a google sheet document with multiple sheets that have items listed each with a checkbox. I'd like to have each item that is checked be returned in a separate sheet in order to create a list. I've tried a few VLOOKUP formulas as well as combinations of IF/MATCH logic to get there but nothing seems to be working. Here's what I'm looking at:

enter image description here

Id like the list to return the "Item Location" for each column with a checked checkbox.




Aucun commentaire:

Enregistrer un commentaire