Microsoft Office 365 Vlookup. Use VLOOKUP when you need to find things in a table or a range by row. In the following table, we want to retrieve the number of units sold for Kale.
Bill uses the example of updating prices in a product list to introduce the value of this time-saving function. For the moment, XLOOKUP is only available to users on the Insiders program. That means you can use XLOOKUP to look up and extract information from within a range.
If Vlookup is false (not equal to the sample value), the formula returns False.
Bill uses the example of updating prices in a product list to introduce the value of this time-saving function.
In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Tip: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.