Unlike Filter and LookUp, the Search function uses a single string to match instead of a formula. Filter and Search return a table that contains the same columns as the original table and the records that match the criteria.