Use combination of IF and Vlookup formula

[NehaSureka]

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

[popipipo]

=IFERROR(VLOOKUP(C3,'lookup sheet'!$B$3:$C$11,2,0),C3)

Try this one

[NehaSureka]

Works perfect, Thanks so much.