Forum Discussion
about the vlookup function
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
If XLOOKUP function is available for your version of Excel I'd recommend to start directly from it.
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.
- thank for all, i'll to check it
