![]() Otherwise, copying the formula to the adjacent cells will return erroneous results. The formula with mixed references must be entered correctly.The value returned by this MATCH function will be used as the column_num argument in the INDEX function. The value returned by this formula will be used as the row_num argument in the INDEX function. ![]() The MATCH function returns the relative position of an item in an array that matches a specified value in a specified order. ➣ Here the range C5:G9 is used for the ‘array’ argument. The INDEX function returns a value or the reference of the cell at the intersection of a particular row and column, in a given range. Finally, you will get the following result. Then enter the following formula in cell C13.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |