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