Excel-Function

Excel Index Match Min to Lookup minimum Value

Finding the lowest value is an important task in Excel worksheet. You can use Excel Index Match Min function to lookup minimum value. If you have large worksheet data in which you want to find the minimum value which match the condition as per your need. There are lot of ways from which you can find out lowest value which match the given condition. You can use Index and Match function along with Min to find out lowest value in the active worksheet. Read More

How to use VLookup with Min Function to get lowest value

If you have a large worksheet data and want to get the lowest value in any column then you must have to use VLookup with Min Function to get lowest value in active worksheet. VLookup function with Min Function allows you to get the lowest value from the list of range. Most of the person have to face this kind of problem but after reading this guide you can easily get the proper solution of your query. Read More

VLookup to return multiple column values

VLookup is an important Lookup and Reference function which allows you to prepare different types of MIS reports. You can use VLookup to return multiple column values at once without any extra effort. During using the VLookup function you must have to again and again type VLookup function to view next column values. But after reading this trick you can quickly view rest of columns values which is based on the lookup value with the help of VLookup function. Read More

How to use Advance Backward VLookup in Reverse Order in Excel

All we know VLookup function is used for search values from left to right side in given array or table. But sometime we need to lookup any value in reverse order. In that situation you need to know how to use advance backward VLookup in reverse order in Excel? In this guide we have to discuss solution to use reverse VLookup in Excel. Read More

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