by Meggen Mills
The VLOOKUP Function is one of the most useful functions in Excel. It is also one of the most confusing and least understood functions. This article describes the formula syntax and usage of the VLOOKUP function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range.
You are a new employee in the Benefits department of a large company with over 2500 employees.
Suppose your department has just sent a notice to selected company employees (approximately 750 employees) notifying them that they still have vacation days available this year, and your boss has asked you to determine the department these selected employees work in. The only problem is that the notice you sent did not ask for their department; you only know their Name and Employee ID number. Continue reading