VLOOKUP Excel 2010 (Simple) HD

This function allows you to retrieve information from a reference table. VLOOKUP takes the lookup value and then matches it to the number in the left column of the reference table; then retrieves the value in the column you assign it (In this case, column 2). Remember: The lookup values in the reference table have to be in increasing order or in alphabetical order for VLOOKUP to work.