Lookup: The LOOKUP function requires that the data be sorted and operates on a one-column or one-row range. Based on the position inside the range, it delivers the value that exactly matches the lookup value whereas The INDEX function lets you specify the row and column numbers to obtain a value from a two-dimensional range (table or array). It gives back the value found where the specified row and column meet.