May 08 2022 03:56 AM
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
May 08 2022 04:19 AM
SolutionIn B2:
=XLOOKUP(C2, ID_range, name_range, "")
or
=IFERROR(VLOOKUP(C2, list_range, 2, FALSE), "")
May 08 2022 04:19 AM
SolutionIn B2:
=XLOOKUP(C2, ID_range, name_range, "")
or
=IFERROR(VLOOKUP(C2, list_range, 2, FALSE), "")