What type of functions are included in the Lookup and Reference category?

Functions for searching and linking data

The correct answer is option 1- Functions for searching and linking data.

The LOOKUP function returns a value either from a one-row or one column range or from an array. The LOOKUP function has two syntax forms: vector and array. The Look Up function can be used as an alternative to the IF function for elaborate tests or tests that exceeds the limit for nesting of IF functions. 

The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value, and then returns a value from the same position in a second one row or one-column range.

The array form of LOOKUP looks in the first row or column of an array for the specified value, and then returns a value from the same position in the last row or column of the array.