VLOOKUP

The vlookup function is useful when you have two tables, where both tables have a common identifier such as a primary key from a database table, and you want to add column to table 1 with data pulled from a matching row in table 2.

Example:

=VLOOKUP(A3,Sheet1!A:B,2,FALSE)

• A3 holds the common identifier (primary key) in table 1
• Sheet1!A:B defines the table 2 area
• 2 is saying we want to fetch and display the value of the 2nd column of table 2
• FALSE says we did not sort the common identifier (primary key) in table 2

• table 2 must have the common identifier as the first column, although you don't have to select an entire sheet - you can define cells or columns within a sheet
• if the identifier in table 2 isn't sorted, the last parameter of the vlookup function must be FALSE
• if you are having trouble getting results and your common identifier is a number, make sure that values in both tables are actually numbers; search Excel help for “convert to number”