i have 2 sheets and on 1 i have a data list and on the other i have a results table.

data list eg:

¦ = Cells

¦ Jo ¦ 35 ¦ 120 ¦
¦ John ¦ 23 ¦ 100 ¦
¦ John ¦ 29 ¦ 100 ¦
¦ Ben ¦ 32 ¦ 120 ¦
etc...

now on the next sheet looks like this:

¦ Name ¦ No1 ¦
¦ John ¦" "¦
¦ John ¦" "¦

now under No1 on first line i want it to say 23 and on second line 29

i know i can vlookup the 23 but how do i get the 29 in the cell below??

need anymore explaination PM me