Search array from multi-line textbox

[acombest]

Column A1 to A100 has been numbered 1x(A1) to 100x(A100). I have a userform with a multiline textbox that has a large amount of data dropped in it (example below). I know how to make a search array but I do not know how to parse out the date the way I want. For set 1 (serial 1 amount 1) I want it to find the corresponding row in cloumn A and place the amount in column B. So for example 10x would be matched with column A row 10 and the corresponding amount should be placed on the same row in column B. So on would be row 11 column B should be 11 row 12 column B 602. Series 2 would follow the same logic but for column C. Lastly Each series of data could be up to 10 rows but will not always be 10 rows.

Serial 1	Amnt 1	Serial 2	Amn2
10X	189	7X	40
11X	11	6X	1018
12X	602	5X	170
13X	25	4X	112
14X	153	3X	102
15X	4	2X	599
16X	1600	1X	3141
17X	54
18X	1
19X	500

<colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody>
</tbody>

the search array I plan on using is as follows, but again I don't know how to parse the information

For i = 1 To Sh1.Cells(Rows.Count, "A").End(xlUp).Row
If Sh1.Cells(i, 1).Value = parsed data and series1 = true then
Sh1.Cells(i, 2).Value = ???? Parsed data match here
End If
Next i