Match

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 ascending order
• 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 descending order
• 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.