Comparing and picking up values from another worksheet

I need help! I have various short worksheets that have to check 1 long reference worksheet.

E.g. In Worksheet 1 Column E (blank), I was wondering if I can enter a formula that checks Worksheet 2... compare names in both worksheets and if the names match and there is an "X" in worksheet 2 column D corresponding to the matching names, then an "X" should be post under column E worksheet 1.

Not sure if this will show well, but I attached a file in notepad.

Worksheet 1
A B C D E
Class Name Annual Default Federal Funds
Principal Browne, Patricia 81396 $81,396.00 (blank)
Vice Prin Reyna Diaz 76960 $76,960.00 (blank)
Teacher ABRAMO, DELILAH 39720 $39,720.00 (blank)
Teacher ALLEN, SARAH 55320 $55,320.00 (blank)


Worksheet 2
A B C D
Name Code Code Def
ABRAMO, DELILAH 0 Unrestricted
ACOSTA, ELIA 7090 ECONOMIC IMPACT AID EIA/SCE
ALLEN, SARAH 0 Unrestricted
ALTEMURA, ROSA 3010 TITLE 1 IASA-1 BASIC GRANTS LOW-INCOME X

Try the following...

Sheet1!E2, copied down:

=IF(INDEX(Sheet2!$B$2:$D$5,MATCH(Sheet1!B2,Sheet2!$A$2:$A$5,0),3)="x","x","")

Hope this helps!