Excel Formulas to Lookup the Last File Version ~ A Complete Guide!!
Tags: excelformula, excelformulas
Published: 2021-01-18 03:59:02

---
title: Excel Formulas to Lookup the Last File Version ~ A Complete Guide!!
published: true
date: 2021-01-11 04:18:23 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-lookup-last-file-version/
---

Do you want to find the last file version in Excel? Then this article will help you. Here we come up with the simple and quick steps to **lookup the last file version in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Find latest file version](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Find-latest-file-version.png)](https://geekexcel.com/excel-lookup-last-file-version/find-latest-file-version/#main)<figcaption id="caption-attachment-20884">Find latest file version</figcaption>

## Generic Formula:

- To look up the latest file version in a list, you can use the below formula.

**=[LOOKUP](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/)(2,1/([ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)([FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(filename,range))),range)**

## Syntax Explanations:

- **LOOKUP** – The [**LOOKUP Function**](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/) in Excel performs an approximate match lookup in a one-column or one-row range and returns the corresponding value from another one-column or one-row range.
- **ISNUMBER** – This function returns TRUE when a cell contains a number, and FALSE if there will not be a number. Read more on the **[ISNUMBER function](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)**.
- **FIND** – In Excel,  the **[FIND function](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)** is used to find out the one text string inside the other.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input ranges in your worksheet.
- **Division (/)** – It is used for dividing values or numbers.

## Practical Example:

Refer to the below example image. Here we will guide you to find the latest file version.

- First, we will give the input values in **[Column](https://geekexcel.com/excel-office-365-columns/) B** and **Column C**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Range-3.png)<figcaption id="caption-attachment-20880">Input Range</figcaption>

- Now, we are going to find the latest version of the File\_A in a worksheet.

![Criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Criteria-7.png)<figcaption id="caption-attachment-20881">Criteria</figcaption>

- Enter the given formula in the **[cell](https://geekexcel.com/excel-cells-options/) F3**, you can also see it in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-6.png)<figcaption id="caption-attachment-20882">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-18.png)<figcaption id="caption-attachment-20883">Result</figcaption>

## Wrap-Up:

In this tutorial, we have described the simple formula to **lookup the last file version in Excel** with a clear-cut example. Hope you like it. Let me know if you have any **doubts** regarding this article or any other article on this site. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)**  and  **[Excel Formulas](https://geekexcel.com/excel-formula/)!!**

### Read Also:

- [**Formulas to Count Rows with Multiple OR Criteria Using SUMPRODUCT!!**](https://geekexcel.com/formulas-to-count-rows-with-multiple-or-criteria-using-sumproduct/)
- **[Excel Formulas to Get the Employee Information with VLOOKUP Function](https://geekexcel.com/excel-formulas-get-employee-information-with-vlookup-function/)**