I have a file that the main purpose is to search a code from the other tab and return it's value in the Search tab.

I tried creating a Match Index and vlookup formulas but it doesn't work.

Please help.

Thanks!