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.

In this guide we show you how Index Match function is better than VLookup function in Excel. There are lot of built-in function in Excel and each function has it’s own importance. If any function does not able to get the correct result as per your need then you have to use more than one functions at once. VLookup function is best function to lookup the values in same or other worksheet. But Index Match function is an alternative way which helps you to get the result when VLookup fails. This guide allows you to quickly use Index Match function with multiple criteria in active Excel sheet.

Step 1: Prepare the following given structure to know how to lookup multiple columns value with Index Match function.

Step 2: To lookup number of units sold which match the given month name and product name in cell E3 and F3 respectively. To do this job you have to type given function in cell G2 =INDEX(C2:C19,MATCH(E2&F2,A2:A19&B2:B19,0)). Now if you press enter key then you will get #VALUE! error value as a result.

So press Ctrl+Shift+Entershortcut key to get the accurate result which match the condition.

I hope this guide helpful for all those guys who are facing issues to get the correct result which match multiple conditions. If you have any query regarding this guide then don’t hesitate to drop the comment. We try to resolve your problem, thanks to all.