2 alternatives to Excel VLookUp — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

2 alternatives to Excel VLookUp

Get PDF file

by on
in Excel Training,Office Technology

VLookUp is a powerful and useful function in Excel. It allows you to look up a value in a list and return any column from the look-up column, left. If your first column had employee ID and your seventh column had ZIP code, VLookUp could find the ZIP code for a whole list of employee IDs. The formula would look similar to this: =VLOOKUP(A1,Employee_Table, 7,0), where A1 contains the employee ID and all employee records are stored in a named range called Employee_Table.

But what if your look-up column isn’t the first one? Your work around might be to copy the look-up column to a newly inserted first column. However, there are two better ways. Meet Index-Match and LookUp. These two methods even allow you to look up a value across a row and return a value from a column.

Index-Match

Technically, Index-Match is more efficient than a VLookUp because it doesn’t have to process the entire table. It only has to process the column or r...(register to read more)

To read the rest of this article you must first register with your email address.

Email Address:

Leave a Comment

 

Previous post:

Next post: