Hi friends,

I am facing a problem combining the IF and Vlookup function.

I have attached my excel sheet for reference.Book1.xlsx

I have a set of codes of which some need to be replaced with the new ones using the lookup sheet and the rest (which are unavailable in lookup sheet) to remain same.

I have added the "final result how it should be" column to show the values that I want in Code final column using the combination of formulas.

Hope I was clear in my question.

Kindly help