This will be hard to explane, but I`ll do my best. I have made a list in sheet1 based on column no.1 in sheet2. This list contains several numbers that`s the same. When I choose a number from this list, I want it to return the value of column2, 3 and 4 in the same row. Now it seem like it choose the highest values.

Hopefully someone can help me solv this problem