Lookup up price for product or service in Excel

In this article, we will learn how to LOOKUP date with last value in list in Excel. Scenario: We have a long table entry of Products and its ser...

How to LOOKUP file with Last ersion

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

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

How to LOOKUP value between two numbers in Excel

In this article, we will learn How to LOOKUP value between two numbers in Excel. Scenario: It's easy to look up a value with one criteri...

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 If Any Duplicates in a Range 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 need to con...

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

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.