???

[pierre]

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 (D15) AS RESULTS.
NB : VLOOKUP IS MY REQUEST TO DO IT IN HERE.....PLEASE

 

[Don Guillett]

You need to learn to use a proper subject line and not to type in all CAPS.