I have following data in my sheet. (please see below)
Rows A B C F
G---col
1 CODE AMT CODE_2 CODE K12----headings
2 SS 50 K12 SS
3 DD 20 S12 DD
4 FF 30 K12 FF
5 GG 10 E12 GG
6 HH 44 T12 HH
7 JJ 60 T12 JJ
8 KK 66 V12 KK
9 UU 70 S12 UU
10 PP 80 Y12 PP
11 ZZ 90 P12 ZZ

I want formula in in cell "G2" which should match or lookup value of
cell "G1" in range "C2:C11" and then match or lookup value of cell
"F2" in range "A2:A11" and then bring up value from range "B2:B11" .
Like in above table formula should bring value "50" in cell "G2" from
column "B".
I want formula something like this "lookup(G1 in C2:C11 then F2 in
A2:A11 then bring value from column B). I hope I explained what I am
trying to say. Please if anybody can help.