This module demonstrates the Excel MATCH function with application to date vectors, sorted in both ascending and descending order.
- SYNTAX: MATCH(lookup_value, lookup_array, [match_type])
- Returns the relative position of the look_up value in the lookup_array
- The match-type is tri-state and takes the values -1, 0, or 1. The default value is 1
- Match-type 1: finds the largest value that is less than or equal to lookup_value. <=lookup-value. The lookup_array must be in
- Match-type 0: finds the first value that is exactly equal to lookup_value. =lookup-value. The lookup_array can be in any order
- Match-type -1: finds the smallest value that is greater than or equal to lookup_value. >=lookup-value. The lookup_array must be in
- Lookup_array must be a single column (m x 1) or single row (1 x n). Match will not work with a multidimensional array
Match worksheet function with a date vector
See the Excel Web App #1 in figure 1.
- Example 1: Nearest match (missing date) in ascending order data (column C)
- Example 2: Nearest match (missing date) in descending order data (column D)
- Example 3: Nearest match (existing date – in set) in ascending order data (column F)
- Example 4: Nearest match (existing date – in set) in descending order data (column G)
- Download the file by using the Microsoft Excel Web App link in figure 1.
- This module was developed in Excel 2013 Pro 64 bit and made available via the OneDrive Excel Web App.