Get Amazon Quiz Answers and Win Sony Alpha 6400 Mirrorless Camera

Index-Match-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

Lookup multiple columns Value with Index Match Function

To lookup multiple column values you can use INDEX MATCH function in Excel. During using the multiple criteria, you can use an array formula to get the accurate result. In this guide we have to show you strength of Excel Index Match function. Sometime VLookup function does not provide correct result in that situation you have to use Index Match function. 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