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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |