???
 

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

???
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pierre" wrote in message
...
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