Replacing numeric codes with corresponding text labels from another tab

[znovznov]

Hi everyone,

I have a file with two tabs. On one tab I have a list of numeric codes in random sequence (Example a in attachment) . On the second tab, these codes are listed in ascending order and have the corresponding values listed in the adjacent column (Example b in attachment).

Is there a way to replace the codes on the first tab with the corresponding values from the second tab?


Thank you!

[bebo021999]

Try VLOOKUP in B2:

=VLOOKUP(A2,Sheet2!$A$2:$B$8,2,0)