Excel 2007 : Assistance with possibly a Vlookup Formula

I'm trying to create a formula that takes into account two columns B & C and matches those two coloums with two columns from another table in A & B and if those match returns what result is listed in column E. Example below...

Book1
B TEST
C PASS

BOOK2
A TEST
B PASS
E 100.00

BOOK1
D = BOOK2 column E "100.00"

My thought is a "Vlookup" or "If" formula would work, just not sure how to combine the two columns.

Thank you in advance.