Hi, welcome to Tut's plus. My name is Bob Flu Sir. When you have a lot of data on a worksheet and you want to extract some of that data to use on other worksheets, the VLOOKUP, MATCH, and INDEX functions are great ways to do it. These functions work in any version of Excel on Windows or Mac, and they also work on the web in Sheets and also on the web versions of Excel. With the VLOOKUP function, the "V" stands for vertical. You have data arranged down columns. There is also an HLOOKUP function where you have data arranged across rows. The "H" stands for horizontal. It works the exact same way as VLOOKUP. You can grab actual data from a worksheet and use it in other sheets. The MATCH and INDEX functions are concerned with the positioning of data, where your data is located, rather than the actual value of the data. If you want to follow along with this tutorial using your own workbook, go right ahead. If you'd like to use the sheet that I have here on screen, you can download it from the Tut's Plus website. Before we start clicking around and writing formulas, I want to give you a little bit of info on how VLOOKUP works. VLOOKUP links to different tables, which can be on the same worksheet or different worksheets, even in different workbooks. It uses a unique identifier, which in this tutorial is going to be an order number. The syntax of the VLOOKUP function starts with an equal sign, followed by the name of the function and an opening parenthesis. There are three required arguments and one optional argument. The first argument is the lookup value, which is the unique identifier. The second argument is the table range, which can be the...
Award-winning PDF software
Video instructions and help with filling out and completing When Form 2220 Index
