It looks up a value in an array and returns the position of the value within the array. MATCH Function The MATCH function is categorized under Excel Lookup and Reference functions. The INDEX function is often used with the MATCH function. The function will return the value at a given position in a range or array. This cheat sheet covers 100s of functions that are critical to know as an Excel analyst. The INDEX function is categorized under Excel Lookup and Reference functions Functions List of the most important Excel functions for financial analysts.
0 Comments
Leave a Reply. |