OK I've had a look.
I think you want on every row to look for G1 in column C and look for
F(row number) in column B and if both found on the same row return the
value in column B. If this is what you need the formula below works.

It only returns a value in your spreadsheet in cell G2 as no other
rows have both K12 and the valuein column F found in columns A & C.


=IF(C2=$G$1,IF(A2=F2,B2,0),0)

Hopefully this is what you need now.