# Formulas

## How To Automatically Insert Date Time In Excel

In the previous article, I told you how to insert the date & time in excel using excel functions or shortcuts manually. In this article, I will tell you how to insert the date & time in one excel cell automatically when you input or update data in another excel cell.

## How To Fix Excel Circular Reference Error There Are One Or More Circular References Where A Formula Refers To Its Own Cell Either Directly Or Indirectly

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 â€¦

## How To Insert Date & Time In Excel With Excel Functions Or Shortcuts

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

## How To Sum Dynamic Range In Excel

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.

## How To Use OFFSET Function 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.

## How To Use Excel HLOOKUP Function With 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 â€¦

## Excel Table Lookup Function Examples

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.

## How To Fix Vlookup Wildcard Not Working Issue

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.

## How To Use Vlookup Wildcard To Implement Partial Match In Excel

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.

## Excel Vlookup Approximate Match And Exact Match Example

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 â€¦