Formulas

When you input a formula in an excel cell, sometimes you may encounter the excel circular reference error. The error message is there are one or more circular references where a formula refers to its own cell either directly or indirectly. This article will tell you how to fix this error on Excel for Windows […]

In this article, I will tell you how to insert the current date and time in Excel using the Excel functions or shortcuts.

The Excel SUM function can calculate the summary of number values in a cell range. But when you add a new number cell before or after the cell range, the SUM function can not add the dynamically added number in the result. This article will tell you how to sum dynamic range in Excel.

The excel OFFSET function can be used to get the reference to a cell or cell range from the starting point ( cell ). It is very useful when you use it correctly. This article will tell you how to use it with some examples.

The excel HLOOKUP function is similar to the VLOOKUP function. It can look up a value in the first row of an excel cell range horizontally. When it finds the matched cell then it will return the cell value in the row specified by the row index number of the cell range. The returned cell

This article will tell you how to use the excel LOOKUP function to look up the provided value in a table column and return the first matched cell data in the same or another column. It will provide several examples to show the use cases. The LOOKUP function is supported in all excel versions.

When I use wildcards in the excel VLOOKUP function to find a wanted cell value, I meet a strange issue. I found the wildcards are not working as I expected. This article will tell you how to fix the VLOOKUP wildcard not working issue.

The excel VLOOKUP function provides a partial match feature. In this feature, you can implement a fuzzy search using wildcards. This article will tell you how to use wildcards to implement partial matches in the excel VLOOKUP function.

In the previous article How To Use VLOOKUP In Excel, I told you how to use the excel VLOOKUP function to search for value in a cell range and return the wanted value in the cell range. In this article, I will tell you what is the difference between VLOOKUP approximate match and exact match

The excel VLOOKUP function can be used to search the values in the first column of the specified cell range. When it finds the value in a cell of the first column of a cell range, it will return the cell value of the specified column number in the same row. This article will tell