If you're only looking up one ID number in A1:

Enter this formula in B1 and copy down to B4:

=INDEX(Sheet1!B:B,MATCH(A$1,Sheet1!A:A,0)+MOD(ROW( A4),4))

If you're lookup multiple ID numbers that are spaced every 4 rows: A1, A5,
A9 etc, then enter this formula in B1 and copy down as needed:

=INDEX(Sheet1!B:B,MATCH(OFFSET(A1,-MOD(ROW(A4),4),,),Sheet1!A:A,0)+IF(MOD(ROW(A1),4), MOD(ROW(A1)-1,4),3))

Biff

"Robin" wrote in message
...
I have Sheet1 and Sheet2. In Sheet1, Column A, I merged rows 1-4 as one
cell
to contain the ID # for the person Column B: name in Column B1, address in
B2, city in Column B3, and phone # in Column B4. When I entered the ID#
in
Column A of merged rows 1-4 in Sheet2, I need the information from Column
B1-B4 of Sheet1 to transfer to Sheet2, Column B1-B4 automatically. I
would
appreciated if someone can give me a hand....thanks.