Index Match for Complex Lookups INDEX function Returns a value or reference of the cell at the intersection of a particular row and column, in a given range. MATCH function returns the relative position of an item in an array that matches a specified value in a specified order. In the previous article, you got […]

What is INDEX function in Excel? It Returns a value or reference of the cell at the intersection of a particular row and column, in a given range. Example 1: How many ways are to use the INDEX function? we can use two ways to use index function: 1 . Array form Returns the value […]

list of shortcuts when designing reports or dashboards in Excel: To do this Press Copies selected cells CTRL + SHIFT + C  Paste Plain Text  CTRL + SHIFT + V selects all cells CTRL + A opens the Format Cells window CTRL + 1 repeats your last command or action F4 Draw a Straight Line […]