How can I find the second (third, fourth, etc.) TRUE checkbox in a column, preferrably using VLOOKUP or similar ?
Hi !
I am making a sheet where I need to retrieve informations depending on whether a checkbox is checked.
Column A has the checkboxes, C and D the information I want to display in a cell. (B is not important and I need the info from BOTH C & D in the same cell)
Now the thing is, I have multiple cells that need information based on these checkboxes, but when I use a simple VLOOKUP of course all of my cells display the same information : the one associated with the FIRST checkbox checked.
Is there a way for me to search for the next checkbox ? (and the next, and the next, etc.)
I've seen QUERY do something similar but only with cells that are directly next to each other, but i have merged cells (that I can't unmerge for layout reasons) AND my cells are not next to each other (they're separated by an empty line), so it didn't work.
I roughly recreated my situation here (with different columns from what I mentioned above, to make things clearer I put everything on the same sheet) :
https://docs.google.com/spreadsheets/d/1_w4xMRvw6SN-Ewl3ZP7iKuAQ8v0VFZHpxkJQELtnbEo/edit?usp=sharing
And here is a visual of my example here as well as the formula I'm currently using for this example (written in the grey boxes) :
=VLOOKUP(TRUE;$H$1:$J$14;2;) & VLOOKUP(TRUE;$H$1:$J$14;3;)
Thank you for your help !