Hi, This seems simple but I am not able to figure it out. I would appreciate
any help.
Please see the example below.

This is the data that I have:
Col A Col B
29890
Price
20010102 48.625
20010103 47.875
20010104 47.875
20010105 48.6875
66157
Price
20010102 28.9375
20010103 30.8125
20010104 31.9375
20010105 30.6875

This is the array im trying to match to (It is on Sheet2):
29890 BP
47896 JPM
66157 USB
69032 MWD

What I need is to copy BP beside 29890 and USB beside 66157 in the data
without changing anything else in column B. This is a small example, my files
contain about 40,000 rows of data that I need to match with their ID numbers.

My data needs to look something like this.

Col A Col B
29890 BP
Price
20010102 48.625
20010103 47.875
20010104 47.875
20010105 48.6875
66157 USB
Price
20010102 28.9375
20010103 30.8125
20010104 31.9375
20010105 30.6875