![how to apply vlookup in excel 2016 how to apply vlookup in excel 2016](https://support.content.office.net/th-th/media/d9011e9d-e702-4fac-8434-1112907e96e3.png)
![how to apply vlookup in excel 2016 how to apply vlookup in excel 2016](https://www.windowssiam.com/wp-content/uploads/2016/05/สูตร-Excel-2016.jpg)
In case you're wondering, the $ signs in the function ($A$6:$C$10) mean that if you copy the formula in B21 to another location, it will continue to look in the product table.
![how to apply vlookup in excel 2016 how to apply vlookup in excel 2016](https://cdn.extendoffice.com/images/stories/doc-excel/vlookup-to-another-workbook/doc-vlookup-to-another-workbook-3.png)
![how to apply vlookup in excel 2016 how to apply vlookup in excel 2016](https://cdn.ablebits.com/_img-blog/vlookup-not-working/no_false_resized.png)
How to apply vlookup in excel 2016 how to#
It is only available to users of Office365 at the moment, but you can read our lesson on how to use XLOOKUP here. Note - Microsoft have announced a new function, XLOOKUP, which improves on VLOOKUP. We'll take you through several simple examples where you can see VLOOKUP in action. In this lesson you'll learn how to use VLOOKUP in your spreadsheets. You would lookup the the person's name in the Salesperson column, and then look in the Sales column to find that person's sales for the month. VLOOKUP is a powerful Excel function that allows you to look for a specified value in one column of data inside a table, and then fetch a value from another column in the same row.Īn example where VLOOKUP might be useful is if you have a monthly sales report in Excel, and want to find the sales made by a specific salesperson from within a monthly sales report.