Getting complete control over your papers at any moment is essential to relieve your everyday tasks and boost your productivity. Achieve any objective with DocHub features for document management and convenient PDF file editing. Gain access, change and save and incorporate your workflows with other secure cloud storage.
DocHub offers you lossless editing, the opportunity to work with any formatting, and securely eSign documents without searching for a third-party eSignature option. Make the most of your file management solutions in one place. Try out all DocHub features right now with the free profile.
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