Perhaps a simple INDEX/MATCH would serve your intents just as well?
Assuming source data is in a sheet: x, in cols A to C, data from row2 down
where col A = staff ids, cols B to C contain other data
In another sheet,
You have your staff ids list in A2 down
Place in B2:
=IF(ISNA(MATCH($A2,x!$A:$A,0)),"",INDEX(x!B:B,MATC H($A2,x!$A:$A,0)))
Copy B2 to C2, fill down as far as required. Cols B to C will return the
data corresponding to your staff ids from the source sheet x's cols B and C.
Adapt / extend to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---