Match-Function

How to use VLookup Match function in Excel

VLookup Match one of the most powerful and important function in Excel. Sometime we need to use VLookup and Match function together to lookup specific value. If you need better control over during lookup and match the value then you must have to know how to use VLookup Match function in Excel. This dynamic function allows you to reduce the chances of error and improve the capability of VLookup function. Read More

How to apply multiple criteria using match function in Excel

Match function in Excel allows you to search for a value in an array and return the relative position of the item in specific order. Sometime you need to apply more than one criteria in that case you can use Match function in Excel. Excel Match function is an important function which is located in Lookup and Reference category. 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

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

How to compare data between two lists in Excel

During working on Excel you want to check if any particular data of one column matched with another column data or not ? You can easily compare two list data in Excel using few simple tricks. In this guide we have to discuss how to compare data between two lists in Excel. Read More

How to use Index Match function in Excel

Just like VLookup function, Match and Index function also used for lookup purpose in Microsoft Excel. Index Match function in Excel works right to left, while VLookup works left to right. In this guide we have to discuss how to use Index Match function in Excel. Read More