Vlookup formula error

%3CLINGO-SUB%20id%3D%22lingo-sub-2743933%22%20slang%3D%22en-US%22%3EVlookup%20formula%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2743933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309897i7555D9F90B0FAE72%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22vlookupFormula%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EvlookupFormula%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309898iF0EF6AB84EC372D2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22Result%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EResult%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2743933%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-2743948%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20formula%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2743948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1153575%22%20target%3D%22_blank%22%3E%40MAAlam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20names%20are%20in%20column%20B%2C%20not%20in%20column%20A%2C%20so%20the%20lookup%20range%20should%20be%20B3%3AE22%2C%20and%20the%20column%20index%20should%20be%204%20instead%20of%205%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DVLOOKUP(G4%2C%20B3%3AE22%2C%204%2C%20FALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

vlookupFormulavlookupFormulaResultResult

1 Reply

@MAAlam 

The names are in column B, not in column A, so the lookup range should be B3:E22, and the column index should be 4 instead of 5:

 

=VLOOKUP(G4, B3:E22, 4, FALSE)