The output is the first position found for the given value. If we want to know where “Mar” month occurs, we can use the MATCH function.īelow is the syntax of the MATCH function MATCH Function The MATCH function looks for a specific value and returns its relative position in a given range of cells. In the above data, we have months from A2 to A6. For example, look at the below image of the data. Read more that looks for the position of the lookup value in the mentioned lookup array. ![]() The corresponding match is a piece of information associated with the value being searched. The MATCH function is a lookup function Lookup Function The LOOKUP excel function searches a value in a range (single row or single column) and returns a corresponding match from the same position of another range (single row or single column). How to Use Application.Match Function in VBA?.
0 Comments
Leave a Reply. |