LOOKUP Function Archives

Excel Formula to Lookup Value in Table (3 Suitable Examples)

Aug 11, 2022 Excel Basics

When working with an enormous dataset, it is a very frequent need for us to find some value in the table of the dataset. Finding it manually and ...

Bonus Calculation as per Bonus Act in Excel (3 Suitable Examples)

Jul 21, 2022 Excel Formulas

When you maintain a company, you have to give some bonus to your employees to make them more dedicated to your company. It is a trendy policy in ...

How to Get Stock Quotes in Excel (2 Easy Ways)

Jun 12, 2022 Excel for Finance

In this article, we will learn to get stock quotes in Excel. A stock quote represents the most recent price of a stock on an exchange. We can use 2 ...

How to Separate Date from Text in Excel (4 Methods)

May 31, 2022 Excel Formulas

In this article, I will discuss how you can separate the date from text strings in Microsoft Excel. While working with excel, often we receive ...

Separate Decimal Numbers from Text in Excel (6 Quick Ways)

Jun 22, 2022 Excel Formulas

This article will show how to separate decimal numbers from text in Excel. The following image highlights the purpose of this article. ...

How to Extract Numbers after a Specific Text in Excel (2 Suitable Ways)

Jun 22, 2022 Excel Formulas

In this tutorial, we will demonstrate how to extract numbers after a specific text in Excel. In many instances, we need to extract a specific part of ...

Excel Formula to Move Data from One Cell to Another

May 31, 2022 Excel Basics

Often in Excel users need to move data from one cell to another. Whatever may be the reasons; referencing, lookup, criteria matched, etc. users ...

How to Calculate Weight Loss Percentage in Excel (5 Methods)

May 30, 2022 Excel Formulas

Users use Excel as a tool to track certain things such as Costing, Weight Loss, etc. Using a worksheet to calculate weight loss percentage in Excel ...

How to Find Last Occurrence of a Value in a Column in Excel (5 Methods)

May 30, 2022 Excel Formulas

If you want to Find Last Occurrence of a Value in a Column in Excel, this article is for you. Here, we will walk you through 5 easy and handy ...

How to Extract Data from a List Using Excel Formula (5 Methods)

Jul 18, 2022 Excel Basics

In Microsoft Excel sometimes we may need to extract data from a range or list. This process can be done in various ways. Today in this article, I am ...

How to Extract Unique Items from a List in Excel (10 Methods)

Jul 24, 2022 Excel Formulas

If you want to Extract Unique Items from a List in Excel, this article will be very helpful for you. Here, we will walk you through 10 easy methods ...

How to Find Last Non Blank Cell in Row in Excel (5 Methods)

Jul 25, 2022 Excel Formulas 4

It is not a matter of astonishment that we might face the requirement to find last non blank cell in row in Excel. Here, we will try to sort out some ...

How to Find Last Row with a Specific Value in Excel (6 Methods)

Jul 24, 2022 Excel Formulas

Here, we have a sample dataset containing Customer Name, Gender, Loan Purpose, Job, and Credit Risk. As we can see, there is repetition in the ...

How to Use Excel Formula to Find Last Row Number with Data (2 Ways)

May 26, 2022 Excel Formulas

In this tutorial, we will demonstrate how to use an excel formula to find the last row number with data. While working in Microsoft Excel we might ...

How to Autofill Blank Cells in Excel with Value Above (5 Easy Ways)

May 25, 2022 Excel Basics 1

In this tutorial, we will show you how to autofill blank cells in excel with a value above. Suppose we have a dataset that contains blank/empty ...