Help with lookup excel 2003

[dee101]

I have numbers in column A and numbers in column D, and letters in column E I need to look for the number that is in A2 in column D and give me the letter that is in column E. the number and letters are not in order, tried this but it did not work
VLOOKUP(A2,$D$2:$E$27,2)

 

[VoG]

Try

=VLOOKUP(A2,$D$2:$E$27,2,FALSE)