Learn How to Lookup Last File Version in Microsoft Excel
The main purpose of this formula is to lookup the latest file version in a list. Here we will learn how to perform a lookup for the last file version in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the LOOKUP, ISNUMBER, and FIND functions, you can able lookup the latest file version in a list.
So, with the help of this formula, you can able to perform a lookup for the last file version in the given data range in the workbook in Microsoft Excel.
General Formula to Lookup Last File Version
=LOOKUP(2,1/(ISNUMBER(FIND(filename,range))),range)
The Explanation to Lookup Last File Version
So we know that with the help of the given formula above, you can able lookup the latest file version in a list. Here we will learn how to perform the lookup for the last file version in the given data range in the workbook in Microsoft Excel.
As we know, we have a number of file versions listed in a table with a date and user name. Note that file names are repeated with a counter at the end as a revision number. Given a file name, we want to retrieve the name of the last or latest revision.
The challenge is the version codes at the end of the file names make it harder to match the file name. By default, Microsoft Excel match formulas will return the first match, not the last match.
So now you have learned how to perform the lookup for the last file version in the given data range in the workbook in Microsoft Excel.