LOOKUP file with last version

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...

Lookup & SUM values with INDEX and MATCH function in Excel

In this article, we will learn how to Lookup & SUM values with INDEX and MATCH function in Excel. For the formula to understand first we need to ...

LOOKUP value between two numbers

In this article, we will learn how to LOOKUP value between two numbers in Excel. Let's first get the knowledge about the function. LOOKUP functi...

Get the cell value at a given row and column number

In this article, we will learn about how to get the cell value at a given row and column number in Excel. To get the cell value you need to know th...

How to know duplicates in a list in Excel

In this article, we will learn about how to know if the list has duplicate values in excel. When a list contains a lot of values and we needed to c...

How to use VLOOKUP with Different Excel workbook

In this article, we will learn about how to  with VLOOKUP function in Excel. First we should understand a little about, What is VLOOKUP function? ...

Custom Excel XLOOKUP Function

The XLOOKUP function is exclusive to the insider program of office 365. The LOOKUP function has many functionalities that overcome many of the weaknes...

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube