![](https://cdn-0.access-excel.tips/wp-content/uploads/2014/12/feature_excel-150x150.png)
Excel Lookup Function lookup multiple criteria not in first column
In this tutorial, I will explain how to use Excel Lookup Function to lookup multiple criteria while the lookup value is not in first column of lookup range. The reason for writing this article is that Vlookup can only lookup one criteria and lookup value must be in the first column of lookup table.
You can also use SUMPRODUCT Function to achieve the same result in the below article.
Excel SumProduct lookup multiple crite...
Read More