Oct 08 2020 12:48 AM
Oct 08 2020 01:04 AM
Oct 12 2020 02:28 AM
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.