In this entryway, stone tiles run right down the middle of the hall with wood on either side, almost like a carpet. I love the tone-on-tone look of the dark espresso color for both materials. Inspiration for a contemporary front door in Toronto with a single front door and a dark wood front door.
Example 1 - Omitting the Reference Argument with the ROW Function. 1  Click on cell B2 to make it the active cell; 2  Type the formula =ROW() into the cell. 3  Press the Enter key on the keyboard to complete the function;  The number  2  should appear in cell B2 since the function is located in second row of the worksheet;
The MATCH function can be used to return values for both the row_num and column_num arguments in the INDEX function. 1  Set up the worksheet as shown above. 2  Enter the following formula in cell C7: =INDEX($B$2:$D$4,MATCH(B7,$A$2:$A$4,0),MATCH(A7,$B$1:$D$1,0)) 3  Press the Enter key to see the result.