Lookup and Reference Lists

[deliver2ron]

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

 

[Herbert Seidenberg]

Two solutions with dubious utility:
http://www.savefile.com/files/1498829