I know there must be a solution for this, just can't figure it out:
Row 1 has a set of triggeres (in different columns): 1,0,1,0,1
Row 2 has corresponding values: a,b,c,d,e
I need a formula that would look at triggers and for each trigger equal to 1, it should pick up the values from Row 2...