Searching and correlating

Hi, this is my first post on the forum. Looks Great!! "

I have the following issue to solve and perhaps you can help me. Here we go;

The information we have:

1) We have data of correlative codes between industries. The “old” codes (column i) and the “new” codes (column K)
2) We have data that are industry codes, mixed old codes with new ones (column M). This is the data that need to be corrected.

What we need?

Fill the column N with the new correlative code to column M. So the formula on column M should do something like that:
- Look for the code on same road in column M.
- If the code in M same road is NEW (some code in column K); copy the same code. Image attached N19 to N24 are example of this.
- If the code is OLD (some code in column i); fill N cell with the NEW correlative code. Image attached N7 to N18 are examples of this.

Does is possible to Excel to do this? If the answer is YES; which might be the formula on N column?

Thanking in advance so much.

PS

Average Humans knowledge increase exponentially, but each day it pass, each day goes faster.