Reverse vlookup
=INDEX(B:B,MATCH(TEXT(D9,"0"),D:D,0),0)
Text(xx,"0") convert number to text
MATCH(find_text,D:D,0) return index found
INDEX(B:B,index,0) return data follow index
Multi-condition sum
=SUMIFS(L:L,B:B,"FR",K:K,$B3)
SUMIFS(sum_column,condition1,find1,condition2,find2)
