VLOOKUP is not working in Cell: G21

%3CLINGO-SUB%20id%3D%22lingo-sub-1961747%22%20slang%3D%22en-US%22%3EVLOOKUP%20is%20not%20working%20in%20Cell%3A%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1961747%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20the%20attached%20file%2C%20VLOOKUP%20is%20not%20working%20in%20Cell%3A%20G21.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20with%20the%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1961747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1963017%22%20slang%3D%22en-US%22%3ERE%3A%20VLOOKUP%20is%20not%20working%20in%20Cell%3A%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1963017%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2101410%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20is%20not%20working%20in%20Cell%3A%20G21%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2101410%22%20slang%3D%22en-US%22%3EThe%20problem%20here%20is%20last%20argument...%20It%20must%20be%200%20or%20false.%3CBR%20%2F%3EHope%20that%20help%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

With the attached file, VLOOKUP is not working in Cell: G21.

 

Please help me with the function.

 

Thanks in advance.

2 Replies
The problem here is last argument... It must be 0 or false.
Hope that help