In this article, we will learn how to get the newest file version using Excel LOOKUP function.
LOOKUP function finds the value in the range and returns the value from the range or its corresponding value. But here we will be using one of the properties of the LOOKUP function i.e. if LOOKUP function can't find an exact match of lookup value, it will match with the last biggest value in the range. (the biggest value, in the range, but smaller than the lookup value).
Let’s understand this by using the above stated formula in an example
Here we have file versions in the first column and we need to find the last version for the FileA.
Use the formula in the D4 cell:
Here the range is named range for the A2:A9 array.
Press Enter to get the results.
As you can see we got the last file version using the LOOKUP & FIND function.
Hope you understood how to use the LOOKUP function in Excel. Explore more articles on lookup value here. Please feel free to state your queries below in the comment box. We will certainly help you.
Use INDEX and MATCH to Lookup Value
How to use the INDEX function in Excel
How to use the MATCH function in Excel
How to use LOOKUP function in Excel
How to use the VLOOKUP function in Excel
How to use the HLOOKUP function in Excel
If with conditional formatting
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.