In an INDEX(/MATCH( array formula need to go down X number of rows until a term is found

My issue concerns going down X number of rows in a data set. Due to the fact that the data set I am pulling from is not standarized, and roughly 10% of the data set has two extra rows of extraneous data below the reference cell (foreign currency balances which I don't need). The point in my formula I need help with is the "+2" (down two rows) condition. I needed it so that the "+2" is replaced with a condition inwhich after the reference cell in the INDEX( and MATCH( function is found the command goes down "X" number of rows until the term "USD" is found. My formula is as follows:

{=IFERROR(INDEX('SHEET1'!$A$9:$O$10000,MATCH((RIGHT(C7,8)),(LEFT('SHEET1'!$A$9:$A$10000,8)),0)+2,11),INDEX('SHEET1'!$A$9:$O$10000,MATCH((RIGHT(C8,8)),(LEFT('SHEET1'!$A$9:$A$10000,8)),0)+2,11))}

An example of the reference data is provided below: The first account (Mr. Pink) has the extraneous data (information for the YEN); the second account (Mr. White) does not have the extraneous data, and lists the USD balance two rows down from the reference account number and 11 columns over. With the current construction of my formula, and account which has the extraneous YEN data, returns that data, and I am looking for a solution so that following the formula finding the reference account number the next condition looks for the term "USD", and once found returns the cell 11 columns over from that cell.

XX5309 Mr. Pink

YEN 0.00886700 3,575,050.00 49.72 3,575,050.00 49.72 0.00 0.00 0.00 3,575,050.00 49.72 3,575,050.00
USD 1.00000000 $32,054.11 50.28 $32,054.11 50.28 $0.00 $0.00 $0.00 $32,054.11 50.28 $32,054.11

xx8761 Mr. White

USD 1.00000000 $392.60 0.56 $392.60 0.56 $0.00 $0.00 $0.00 $392.60 0.56 $392.60 $392.60