Get Amazon Quiz Answers and Win Sony Alpha 6400 Mirrorless Camera

Index-Function

Triple VLookup with Index Match function in Excel

Sometime we need to apply triple VLookup in active worksheet and want to get the result which fulfil all given three criteria. In that situation you must have to use Index Match function at the place of applying VLookup function in active worksheet. In this article we have to discussion how could you easily apply triple VLookup with Index Match function in active worksheet. 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 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