about the vlookup function

%3CLINGO-SUB%20id%3D%22lingo-sub-1757668%22%20slang%3D%22fr-FR%22%3Eabout%20the%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1757668%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20everyone%2C%20%3CBR%20%2F%3E%20it's%20me%20again%20I%20would%20like%20to%20ask%20something%20about%20the%20vlookup%20function.%20%3CBR%20%2F%3E%20what%20is%20this%20function%20for%20and%20how%20to%20apply%20it%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1757668%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EBI%20-%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1757704%22%20slang%3D%22en-US%22%3ERe%3A%20about%20the%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1757704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F801624%22%20target%3D%22_blank%22%3E%40dvanlocyriel95%3C%2FA%3E%26nbsp%3BHow%20about%20this%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Frecherchev-recherchev-fonction-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Frecherchev-recherchev-fonction-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1757708%22%20slang%3D%22fr-FR%22%3ERe%3A%20about%20the%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1757708%22%20slang%3D%22fr-FR%22%3Ethank%20for%20all%2C%20i'll%20to%20check%20it%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi everyone,
it's me again i would like to ask something about the vlookup function.
what is this function for and how to apply it

Thank you

4 Replies
Highlighted
thank for all, i'll to check it
Highlighted

@dvanlocyriel95 

 

Hi, 

Let's say you have huge data e.g. for sales but you want to get selected invoices amount, the quick way of doing this is applying vlookup formula. An example of the formula=VLOOKUP(H2,C3:E9,2,FALSE)

H2 this is where you have typed what you are looking for.

C3:E9 is the whole data highlighted

2 is the column number where the results that you want to see is located within C3:E9

False - Exact Match

 

I hope this is helpful. 

Highlighted

@dvanlocyriel95 

If XLOOKUP function is available for your version of Excel I'd recommend to start directly from it.