In this HR Resources Post, we’ve created a YouTube clip explaining the vLookUp formula, of all the Excel formulas I use in HR, the vLookUp is the most useful and one I use virtually every time I open Excel. In this video tutorial we go through two usages of vLookUps, firstly how to import data from one spreadsheet to our master spreadsheet, and secondly on how to set up an Excel template that we can drag and drop HR data into – extremely useful if you’re setting up Excel spreadsheets for others to drop data into.
You may also like