Excel formula

[shrhma]

Hi 

I need a formula for excel to do the following.

I have a list of letter/number code e.g jk57p7kj012, and each code is linked to a name. I need to find out each codes name on a spread sheet quickly.

here is a screenshot of the main table, below is a screen shot of the list of codes and names 

how can i do this. Any help would be amazing! thanks

[#2 · Accepted solution]

@shrhma 

In B2:

=XLOOKUP(C2, ID_range, name_range, "")

or

=IFERROR(VLOOKUP(C2, list_range, 2, FALSE), "")

[#3]

Thankyou!!