using vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-2654012%22%20slang%3D%22en-US%22%3Eusing%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654012%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20do%20a%20vlookup%20and%20put%20the%20description%20in%20the%20column%20f.%20I%20can%20not%20get%20the%20formula%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2654012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2654068%22%20slang%3D%22en-US%22%3ERe%3A%20using%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1129824%22%20target%3D%22_blank%22%3E%40jplamann%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20F1%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DVLOOKUP(E1%2C%24J%244%3A%24K%246%2C2%2CFALSE)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to do a vlookup and put the description in the column f. I can not get the formula to work.

1 Reply

@jplamann 

In F1:

=VLOOKUP(E1,$J$4:$K$6,2,FALSE)

Fill down.