SOLVED

Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3339588%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3339588%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1384159%22%20target%3D%22_blank%22%3E%40shrhma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B2%3A%3C%2FP%3E%0A%3CP%3E%3DXLOOKUP(C2%2C%20ID_range%2C%20name_range%2C%20%22%22)%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(C2%2C%20list_range%2C%202%2C%20FALSE)%2C%20%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3339589%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3339589%22%20slang%3D%22en-US%22%3EThankyou!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3339542%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3339542%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20formula%20for%20excel%20to%20do%20the%20following.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20letter%2Fnumber%20code%20e.g%20jk57p7kj012%2C%20and%20each%20code%20is%20linked%20to%20a%20name.%20I%20need%20to%20find%20out%20each%20codes%20name%20on%20a%20spread%20sheet%20quickly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3Ehere%20is%20a%20screenshot%20of%20the%20main%20table%2C%20below%20is%20a%20screen%20shot%20of%20the%20list%20of%20codes%20and%20names%26nbsp%3B%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3Ehow%20can%20i%20do%20this.%20Any%20help%20would%20be%20amazing!%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3339542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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.

 

shrhma_0-1652007297100.png

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

shrhma_1-1652007355548.png

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

2 Replies
best response confirmed by shrhma (New Contributor)
Solution

@shrhma 

In B2:

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

or

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

Thankyou!!