Google Spreadsheet search /w multiple variables, bitwise 1 or 0 when found -

hi lookup 3 variables , return yes if 3 found in columns above us. sample function provided below.

=arrayformula( sum( (t$2:t18=t19) * (c$2:c18=c19) * (k$2:k18="✓")) ) 

the problem work incremental check. if check 1 correct returns 1, if both 1 , 2 found returns 1+2, if both 1,2 , 3 found returns 1+2+4. (i think bitwise solution)

in short, instead of resulting in 2

111 = 1 001 = 0 101 = 0 111 = 1 

it should check column 1 first. if found return 1 (for found in column) if first found check 2nd column, if found return 2 (for found in second column also)

link sample data attached

can done?

(ps. based on 1, 2 or 3 set status new, in progress or complete)

please try:

=(t$2:t18=t19)+((t$2:t18=t19)*(c$2:c18=c19))+((t$2:t18=t19)*(c$2:c18=c19)*(k$2:k19=k19)*2)