# How to use Vlookup function in Excel

The VLOOKUP function is one of the most popular functions in Excel.

The VLOOKUP function is one of the most popular functions in Excel.

Learn how to get the day of the week of a date in Excel and how to get the number of weekdays or workdays days between two dates.

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.

The RANK function in Excel returns the rank of a number in a list of numbers.

This example describes how to count the number of words in a cell.

This example teaches you how to simulate the roll of two dice in Excel.

Excel has two useful functions when it comes to generating random numbers.

An easy formula that returns the quarter for a given date.

The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

The OR function in Excel returns TRUE if any of the conditions are true and returns FALSE if all conditions are false.

The percent change formula is used very often in Excel.

This example teaches you how to use the PERCENTILE and QUARTILE function in Excel.

The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.

Use the SEARCH function in Excel to find the position of a substring in a string.