Excel 2016 - VLOOKUP Function Tutorial - How To Use The Vertical Lookup Formula in Windows 10 Office

in microsoft •  7 years ago 


In this Microsoft Excel 2016 Tutorial on Windows 10, I demo how to use the VLOOKUP function to reference different product information. VLOOKUP looks for the value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in ascending order. The Lookup value is the value to be found in the first column of the table, and can be a value, a reference or a text string. The Table Array is a table of text, numbers, or logical values, in which data is retrieved. Table array can be a reference to a range or a range name. The column index number is the column number in table array from which the matching value should be returned. The first column of values in the table is column 1. Finally, the range lookup is a logical value to find the closest match in the first column. True or omitted; find an exact match = false. This Office 365 tutorial is meant for beginners who would like to learn more about how to use the Office Suite.


▶️ DTube
▶️ IPFS
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Congratulations @instructormorgan! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

You got your First payout
Award for the number of upvotes

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here

If you no longer want to receive notifications, reply to this comment with the word STOP

Upvote this notification to help all Steemit users. Learn why here!

Do not miss the last announcement from @steemitboard!