Excel Basics

Why VLOOKUP Returns #N/A When Match Exists (with Solutions)

We use the VLOOKUP (Vertical Lookup) function to search for a value vertically in a column and then return a corresponding value from another column. ...

Excel Conditional Formatting Text Color (3 Easy Ways)

While working with a big dataset that contains numerous entries, we need to find texts based on their specific text values, conditions, and duplicate ...

INDEX MATCH vs VLOOKUP Function (9 Examples)

In this article, you will get the differences between the INDEX MATCH vs VLOOKUP function. To look up a value in a large dataset you can use both ...

Use VLOOKUP with Multiple Criteria in Excel (6 Methods + Alternatives)

If you have worked with Microsoft Excel for a while, you know how functional the VLOOKUP function is. We can search for an element from a large ...

How to Use VLOOKUP Function in Excel VBA (4 Examples)

In this article, I’ll show you how you can use the VLOOKUP function of Excel in VBA. You’ll learn to use the VLOOKUP function with a user-defined ...

How to Remove Checkbox in Excel (6 Methods)

Sometimes while using Excel we have to use a checkbox to keep track of the progress of our To-do list or the opinions of the customers etc. After the ...

How to Name a Cell in Excel (4 Easy Ways)

We can name multiple items in Excel. Name a cell is one of them. There are items to name such as, ⧭ A Cell or A Range of Cells ⧭ Certain Values ...

Macro to Insert Row and Copy Formula in Excel (2 Methods)

In this article, I’ll show you how you can develop a Macro to insert a row and copy a formula using VBA in Excel. You’ll learn to insert one or more ...

How to Clear Contents in Excel Without Deleting Formulas (3 Ways)

If your datasheet contains both contents and formulas you need to apply some techniques to delete the contents without affecting the formulas. In ...

Apply Conditional Formatting to Each Row Individually: 3 Tips

Conditional formatting is a versatile feature embedded in Excel, that comes up with a lot of flexibilities in terms of highlighting cells. You can ...

How to Return Value if Cell is Blank (12 Ways)

If you are looking for some of the easiest ways to return value if a cell is blank, then you will find this article useful. So, let’s get started ...

Change Font Color Based on Value of Another Cell in Excel (2 Methods)

Changing the font color of a dataset is one of the essential tasks of Microsoft Excel. We do it to have a clear and attractive look at our dataset. ...

How to Add Leading Apostrophe In Excel (5 Ways)

You can convert a number into text by adding a leading apostrophe. From this Article you’ll get to know how you can add leading apostrophe in Excel. ...

Excel Data Validation Alphanumeric Only (Using Custom Formula)

Alphanumeric characters are a mix of alphabetical and numerical characters. There are 36 (A-Z and 0-9; case insensitive) or 62 (A-Z, a-z and 0-9; ...

How to Combine Cells in Excel (4 Methods + Shortcut)

While dealing with Microsoft Excel, we often have to combine values in cells in different situations. MS Excel has numerous ways to join cells, and ...

ExcelDemy
Logo