VLOOKUP allows you to type one bit of information into a cell, then have all the related information from a list or database populate next to it. For example, if you type in someone’s name and hit enter, Excel will search the list or database and pull up their address, SS#, Telephone number or any other related information. It’s a lifesaver if you use Excel for data storage.
For some free Excel VLOOKUP Tutorials click here.
Jared Hawk teaches Excel Classes in Boise, ID. He is also a contributing author to www.masterthebusiness.com.