The information in this article applies to:
SUMMARY
In Microsoft Excel you can use the LOOKUP() function to search for a
value within an array of sorted data and return the corresponding
value contained in that position within another array. If the lookup
value is repeated within the array, it will return the last match
encountered. This behavior is true for the VLOOKUP(), HLOOKUP(), and
LOOKUP() functions.
MORE INFORMATION
The example below contrasts the results you get when you use the
LOOKUP() function with the results you get when you use the INDEX()
and MATCH() functions:
ExampleIn a new worksheet, type the following data:
In this example worksheet, cell C1 will return the last match of the value 1, resulting in the text string "Blue" being returned to the cell. However, cell C2 will return the first match of the value 1, resulting in the text string "Red" being returned to the cell. Note that when you use the INDEX() and MATCH() functions, the lookup array does not need to be sorted in ascending order; however you must specify a match_type argument of 0 in order to return the correct value. REFERENCES
"Function Reference," version 4.0, pages 221, 236, 264, 267, 450
Additional query words: howto
Keywords : kbdta xlformula |
Last Reviewed: April 7, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |