Getting comprehensive power over your files at any time is important to alleviate your everyday tasks and increase your productivity. Achieve any objective with DocHub features for papers management and convenient PDF file editing. Gain access, change and save and incorporate your workflows with other secure cloud storage.
DocHub provides you with lossless editing, the possibility to work with any format, and safely eSign documents without looking for a third-party eSignature alternative. Make the most from the file managing solutions in one place. Try out all DocHub capabilities right now with the free account.
hi welcome to Tuts 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 Google sheets and also on the web versions of Excel with the vlookup function and the V stands for vertical you have data arranged down columns and by the way there is also an H lookup function where you have data arranged across rows H is horizontal and it works the exact same way as vlookup so theres really no need for me to cover that in this tutorial you can grab actual data from a worksheet like you see here and use it in other sheets where as the match and index functions are really concerned with the positioning of data where your data are located rather than what is the actual value of the data if you want to follow along in this tutorial using your own workbook g