Getting complete power over your files at any moment is essential to alleviate your everyday tasks and boost your efficiency. Achieve any goal with DocHub tools for papers management and practical PDF file editing. Gain access, modify and save and integrate your workflows with other protected cloud storage services.
DocHub provides you with lossless editing, the chance to work with any format, and securely eSign documents without the need of looking for a third-party eSignature software. Get the most from the file management solutions in one place. Check 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