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