41,261 views
🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel... #Excelentejoao #Excel #Dashboard In this Excel video lesson, we will learn how to use the Vlookup function in Excel with more than one result in Excel. In other words, we will return multiple values with the Vlookup. The Vlookup function is one of the best functions in Excel and one of the main functions in Excel because Vlookup is a formula for automating tasks in Excel and also for automating repetitive processes with Excel. So, if you need to save time with Excel, Vlookup is among the best Excel formulas and functions. Vlookup is a search function. Instead of you searching for what you need, Vlookup searches for it for you. Vlookup means vertical search or vertical search. For example, let's say you have a table in Excel with the sales for the entire year. In the first column you have the sales date and in the next column you have the sales for that date. To know how much you sold on a specific date, you don't need to look for this information in your database or in your Excel table, you can simply tell the VLOOKUP function to look for the date you want and the VLOOKUP function will find that date and return how much you sold on that specific date. In this way, the Excel VLOOKUP function is excellent for everyday use and for the job market, as it can automate repetitive tasks.