How to Use the LOOKUP Function With Unsorted Data in Excel

Overview: The paper describes how to use LOOKUP function with unsorted data in excel. In Microsoft Excel, the LOOKUP worksheet function has a vector form and an array form. The vector form of LOOKUP looks in a one-row or one-column range for a value and returns a value from the same position in a second one-row or one-column range. The other form of LOOKUP automatically looks in the first column or row. One can use a combination of the INDEX and MATCH functions, a combination of the OFFSET and MATCH functions, HLOOKUP, or VLOOKUP to provide the same functionality as LOOKUP.