Oct 08 2020 12:48 AM
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
Oct 08 2020 01:04 AM
Oct 12 2020 02:28 AM
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.
Oct 12 2020 08:57 AM
If XLOOKUP function is available for your version of Excel I'd recommend to start directly from it.