For a given file, we want to locate the position (row number) for the last revision.
This array result is fed into the IF function as the logical test.
the row number inside the named range “files” where “filename1” appears.
Use INDEX with this row number to retrieve information related to the last revision (i.e.
full file name, date, user, etc).
SEARCH returns the position offind_textinsidewithin_textas a number.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
you might use INDEX to retrieve individual values, or entire rows and columns.
More than one condition can be tested by nesting IF functions.
The IF…
ROW Function
The Excel ROW function returns the row number for a reference.
For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.
When no reference is provided, ROW returns the row number of the cell which contains the formula.
