Can anyone help me with this issue?

I posted this in general but noone is there today.

I need <bTHE AVERAGE IF</b

average if Column A contains DFW and F 0, then I need G to = Bob
average if column A contains AUS and F 0, then I need G to = Lynette
so on so on so on. And there will be approx 300 If's.