cells: A B C D

range1 M B 9 A
range2 J S 9 C
range3 A S 9 E
range4 D J 9 F
range5 E B 9 B

What I need to do is WRITING IN CELLS : A7 , B7 , C7 RESPECTIVELY
IN ORDER TO HAVE (D1:D5) AS RESULTS.
NB : VLOOKUP IS MY REQUEST TO DO IT IN HERE.....PLEASE