VLOOKUP Function Archives

How to Automate Currency Conversion in Excel (5 Easy Methods)

May 24, 2022 Excel Basics

If you are looking for some special tricks to automate currency conversion in Excel, you've come to the right place. In Microsoft Excel, there are ...

Formula to Convert Currency in Excel (4 Useful Examples)

May 24, 2022 Excel Basics

At times, when dealing with currency, we need to convert currency in Excel very frequently. It is quicker and handier if we can use any formula to ...

How to Make Report Card in Excel (Download Free Template)

May 23, 2022 Advanced Excel

It is a very frequent need for educational institutions to make progress reports for the students. It would be a lot easier if you can make a report ...

Currency Conversion Using VLOOKUP in Excel (2 Suitable Examples)

May 24, 2022 Excel Basics

As of now, Excel doesn’t have any built-in currency conversion tool yet. So we either need at least a basic multiplication formula or other formulas ...

How to Generate a Random String from a List in Excel (5 Suitable Ways)

May 17, 2022 Excel Formulas

In this article, you will learn 5 different ways to generate a random string from a list in Excel with ease. Download Practice Workbook You ...

How to Extract Data from Excel Sheet (6 Effective Methods)

May 13, 2022 Excel Basics

If you are looking to extract data from an Excel sheet to another sheet, then you are in right place. You just have to follow along with this article ...

Excel Hyperlink to Cell in Another Sheet with VLOOKUP (With Easy Steps)

Apr 17, 2022 Excel Formulas

This article illustrates how to create an excel hyperlink to a cell in another sheet along with the VLOOKUP formula. The hyperlink feature in excel ...

How to Create a Table Array in Excel (3 Methods)

Apr 6, 2022 Excel Basics

While using the VLOOKUP or HLOOKUP function, there is a mandatory table array argument where we set the range for looking up values. So to learn how ...

Vlookup with Multiple Criteria without a Helper Column in Excel (5 Ways)

Apr 5, 2022 Excel Formulas

Introducing helper columns to vertically lookup data always brings complexity. It also manipulates the raw data as additional data columns are ...

Return YES If 2 Cells Match in Excel (10 Methods)

Apr 18, 2022 Excel Formulas

We can compare two cells in MS Excel in different ways. Excel offers many easy methods to compare two cells and return a certain value if the values ...

How to Use Custom VLOOKUP Formula in Excel Data Validation

Mar 31, 2022 Advanced Excel

Data Validation in Excel gives you the facilities to set a validation range of data that can help you in many ways like which data you can select or ...

How to Convert Number to Text for VLOOKUP in Excel (2 Ways)

Mar 31, 2022 Excel Formulas

In Microsoft Excel, the VLOOKUP formula is one of the hottest topics that you can find on the internet. There are numerous articles on this topic ...

[Fixed!] Spell Check Is Not Working in Excel (4 Solutions)

Apr 17, 2022 Excel Basics

The spell checker in Excel helps a lot to fix any unexpected errors in spelling. It can auto-correct or give you suggestions. But in some cases, you ...

Excel Formula to Compare Two Cells in Different Sheets (3 Examples)

Apr 20, 2022 Excel Formulas

This article illustrates how to use excel formula to compare two cells in different sheets. Now and then, you might need to compare data in different ...

Formula to Return Blank Cell instead of Zero in Excel (With 5 Alternatives)

Mar 28, 2022 Excel Formulas

You may like to keep blank cells instead of zero values in your dataset. There are several ways to do it. But this article will provide you with the ...