Suppose the mode of income and expenditure is column C, the income is column F, the subtotal is column I, and Goldman Sachs foreign exchange is in line 3.

I3=F3*=LOOKUP(C3, {"Goldman Sachs Foreign Exchange"); “BB”； "one" and "king"; Zhang}, {6.3; 4; 2; 5; 3})

{"Goldman Sachs Foreign Exchange"; “BB”； "one" and "king"; "Zhang" is non-repetitive data of revenue and expenditure method and must be arranged in ascending order. {6.3; 4; 2; 5; 3} is the exchange rate corresponding to each income mode.