Excel-Function

Reverse VLookup in Excel with VLookup Function

Most of the person don’t known about the reverse VLookup in Excel. All we know very well VLookup is an important lookup function which search the value from left to right in given array or table. But sometime you need to lookup the value in reverse order that means right to left. It is not so easy to search the required value in reverse order. But there is no need to worry this guide helps you to know how to use reverse VLookup in Excel with the VLookup function. Read More

How to using logical AND function in Excel

If you want to compare different cells data or values then you must have to know how to using logical functions in Excel. Logical AND function in Excel is one of the most important and useful function of excel. If you have more than one criteria in that case you have to use logical AND function in Excel sheet to get the correct result. Read More

How to use Countif function with wildcards in Excel

Countif is an important function which is used to count number of cells which meet the given single condition or criteria. You can use Countif function to count number of cells which have any number, text or dates that match the given specific condition. But sometime we need to use wildcards for partial matching in the given range of cells in active worksheet. In that situation you must know how to use Countif function with wildcards in Excel Read More

Excel FV Function to know future value of an Investment

Hi friends today we are talking on Excel FV Function to know future value of an Investment. The Excel FV function is an important financial function. The Excel FV function allows you to quickly return the future value of an investment with constant interest rate, payments and periodic. FV stand for future values and this function is located in Formula > Financial library functions. Read More

How to use Excel FV – Future Value Function

Hi, today we are talking on The Excel FV – Future Value Function allows you to return the future value of an investment which is based on a periodic, constant interest rate, constant payments. Future value is an important and popular function which is located in the financial category. You can check this function from Formula tab then Financial functions library.

Read More

How to use index and match functions for advanced lookup in Excel

Hi, today we are talking on Index and Match most popular and powerful function in Microsoft Excel. You can use index match function in excel separately or with combination of other functions as per your need. In this guide we have to discuss how to use index and match functions for advanced lookup in Excel. Index and Match and VLookup functions found in the Lookup and Reference category.  Read More