lookup next value in column

this is my problem

1.............. A..............B..............C............. D..............E
2.............. test1........................................ test1.........350
3.............................................................. test2........ 475
4.............. 350...........................................test3........ 550
5.............. test2..............................................................
6....................................................................................
7.............. 475................................................................
8.............. test3..............................................................
9...................................................................................
10............ 550...............................................................

what I wanna do is to get the number below "test1" in (in row A) into the cell next to test1 in column E (and so on for test2 and 3....
hope hope you understand my question (english is not my native language...)