A lookup table consists of rows and columns of data. A lookup function examines the table either horizontally or vertically and then retrieves the data that corresponds to the argument specified as part of the lookup function.