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.

Yes!!!! Thanks so much!!!!!!

Hi,

It seems was solved the main issue that was finding the correct data. So the 1st formula presented by Martindwilson do the job.

But, how can I take the format of the same cell as well as the data. I mean the color and bold of the font?

Thanks so much in advance!!

SC

Actually what I want is to mantain the orginal format from column "J" on the column "L". Column "L" have the funcion to get the correct data. What I need is the function I need to add to maintain the format of the same data (colun "J").

Thanks so much.

SC

Thanks so much both of you. I wrong interpreted what was conditioonal formating.

PS
About interpretations: Our actions born many times on interpretations. The more we get a better system of interpreting what are we seeing, reading or thinking or feeling, etc (or better said not interpreting so much), the better world we would have!! ....I am not sure but I suposse and this is another interpretation!!