Another option - using mcm's file (thanks for that), put this regular formula in D1 and copy down...
=IFERROR(INDEX($G$1:$G$12,MATCH(A1&B1,INDEX($E$1:$E$12&$F$1:$F$12,0),0)),"Still Pending")

Note: mcm also forgot to mention that his formulas are ARRAY formulas
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.