B2 : =vlookup(A2,Sheet1!$A$2:$K$12000,2,0)
C2: =vlookup(A2,Sheet1!$A$2:$K$12000,3,0)
D2: =vlookup(A2,Sheet1!$A$2:$K$12000,4,0)
E2: =vlookup(A2,Sheet1!$A$2:$K$12000,5,0)
F2: =vlookup(A2,Sheet1!$A$2:$K$12000,6,0)
G2: =vlookup(A2,Sheet1!$A$2:$K$12000,7,0)
H2: =vlookup(A2,Sheet1!$A$2:$K$12000,8,0)
I2: =vlookup(A2,Sheet1!$A$2:$K$12000,9,0)
J2: =vlookup(A2,Sheet1!$A$2:$K$12000,10,0)
K2: =vlookup(A2,Sheet1!$A$2:$K$12000,11,0)

Just a thought ..

Might be a little easier to just fill across from the starting cell's
vlookup in B2 by using an incrementer formula* (for copying across) for the
col_index_num instead of hardcoding it in this instance

Put in B2:
=VLOOKUP($A2,Sheet1!$A$2:$K$12000,COLUMNS($A$1:B1) ,0)
and then copy B2 across to K2, fill down as required

*COLUMNS($A$1:B1) will evaluate to: 2
and when copied across, return: 3,4,5,6, ... in successive columns
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----