VLookup tables

VLOOKUP() allows for easy matching of a lookup value in a table that then returns the corresponding value in one of the other columns of the table.