Source: Microsoft

Date: January 2008

Type: White Paper

Rating: (0)

Save for Later

Email a Colleague

Rate This Asset

DOWNLOAD NOW!

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.

Click here to download now

View all content from this source