Look up existing table to map value - Help understanding the formula

I have been handed an existing document that I need to update and need help to get the formulas working. I have little experience in power query so forgive me if this is basic. The purpose of the doc...