In this article, we will learn how to LOOKUP file with last version in Excel.
Let's first get some knowledge about the function.
LOOKUP function finds the estimated value in the range and returns the value from the range or its corresponding value.
lookup_value: value to look up for
lookup_vector: array where the function looks for the lookup_value.
[result vector]:[optional] if the return array is different from the lookup array.
But here we will be using its one of the attributes of the LOOKUP function i.e. if LOOKUP function can't find an exact match, it will match with just the previous value. It returns the last found value for the previous value. So we will be using the below syntax.
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.
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.