about the vlookup function

[sj093]

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

[#2]

@sj093 How about this?

https://support.microsoft.com/fr-fr/office/recherchev-recherchev-fonction-0bbc8083-26fe-4963-8ab8-93... 

[#3]

thank for all, i'll to check it

[#4]

@sj093 

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. 

[#5]

@sj093 

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