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))}