Graphics of MS Excel 2010 vLookUp Tutorial For

MS Excel 2010 vLookUp Tutorial For HR Practitioners

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.

Get our printable one-on-one meeting template, guide and example questions.

Sign up to our weekly newsletter and receive a FREE copy of our Guide Start Guide To One-on-One Best Practices.

Join forces with other leaders in the People and Culture space.
Get on the waitlist to be part of the community that’s leading change in People and Culture.