My Ex:
Sheet 1
A B
1 100
2 5
6 12
2 200
I need in another sheet ,When I write 2 i can retreive 5 , 200 , ........
A B
2 5
200

I can't do it with LookUp Equations.

Thanks,
Waiting for reply