Here's the situation.  In Sheet1 I have a list of about 1200 items in
following format:

T0000
----
AAA     00000
BBB     11111
CCC     22222

T0001
----
AAA    11111
DDD    33333

and so on.

In Sheet2, as follows:

          T0000     T0500    T0700
AAA
BBB
CCC
DDD

         T0003     T0100     T0900     T1000     T0350
AAA
BBB
CCC
DDD

There are about 300 of these blocks in Sheet2.

And my task is to fill out the blank cells under each id numbers in
Sheet2 with their corresponding values (if any) in Sheet1.  I am
fairly new to Excel and don't have a clue as to how to go about this
problem.  Any suggestions would be appreciated.

Ron