Complicated Formula?

I need a formula and have explored my options with the Conditional Sum
Wizard, Vlookup, SumIf, etc. I can't seem to come up with it. Here
is what I'm trying to accomplish:

I have two files, one large, one small. I want to return a value from
the large one into the small one. I want to match one criteria in the
small file, but there are two criteria in the large file that must
match in order to return the correct answer. The large file is "Test"
and the small file is "Turnkey."

Ok, here's what I need to do:

If any cell in Test file column F equals Turnkey file cell F12, AND if
any cell in Test file column C equals TURL, scan Test file columns G2
through P10453 for the dollar amount applicable to the row that
contains both those criteria (TURL and the text in cell F12 from the
Turnkey file).

I hope this is making sense.