help with combined excel function

Hello A few months ago I was set up in excel some sheets to keep the accounting record and use a function like this:   = YES.ERROR (INDEX (Temp_German! B $ 2: B $ 500; K. ESIMO.MENOR (YES (SERROR ...