We need to find who from this list have salary € 30,000 along with position in Excel. You can download this VBA Match Excel Template here – VBA Match Excel Template VBA Match Function – Example #1 The default value for the match type is +1. For this to happen, the lookup_array must be sorted in ascending order. If match_type = +1 it means that the MATCH function will find out the largest value which is lesser than or equals to the lookup_value. If match_type = 0 means that the MATCH function will find out the value which is exactly the same as that of the lookup_value. For this to happen, the lookup_array must be sorted in descending order. If match_type = -1 means that the MATCH function will find out the smallest value which is greater than or equals to the lookup_value. Arg3 – Match_type – The match type which takes value -1, 0 or 1.Arg2 – Lookup_array – an array of rows and columns which contain possible Lookup_value.Arg1 – Lookup_value – The value you need to lookup in a given array.It is really helpful in analyzing the data and also one line of code can automate the things for you. For example, VBA MATCH is helpful if you have the salary data of employees and you need to find out the numeric position of an employee in your data who has salary less than/greater than/equals to a certain value.

This function becomes useful when you need to evaluate the data based on certain values.

This function in MS Excel VBA finds a match within an array with reference to the lookup value and prints its position. VBA Match has the same use as the Match formula in Excel.

Vba find exact match