Despite the popularity of the lookup functions, there are certain things that they simply cannot handle. So, let us understand how to overcome those obstacles. Let us meet Index and Match.

via The Lookup Alternative — ExcelwithEXCEL