Put in C2:
=IF(ROW(A1)COUNT($B:$B),"",INDEX(X!B:B,SMALL($B:$ B,ROW(A1))))
Copy C2 to E2...

To adapt which cols and/or the order of the cols in X as they should appear
in Y
just adjust the indexed col part, eg: INDEX(X!B:B, ...
within the expressions in C2:E2 to suit before copying down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---