Excel Lookup Function lookup multiple criteria not in first column

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...
More

Excel lookup partial text using Vlookup with Wildcard

This Excel tutorial explains how to lookup partial text using Vlookup Function with Wildcard. Excel Vlookup second matched value or specific occurence Excel Lookup Function lookup multiple criteria not in the first column Excel lookup Function lookup multiple criteria Excel lookup partial text using Vlookup with Wildcard Many people know how to use Vlookup but not many people know Vlookup allows Wildcard in the lookup value. Lets recap the syntax of Vlookup first. Syntax of Vlookup...
More

Excel IFERROR Function

This Excel tutorial explains how to use Excel IFERROR function for worksheet. IFERROR can be used with vlookup to capture ISNA error. You may also want to read: Check Excel #N/A using ISNA Function What is Excel IFERROR Function? Excel IFERROR Function is an error handling function, if an "Error" is found, then a desired value is returned.  This is a new function introduced in Excel 2007, which means Excel 2003 and prior versions cannot be used. Syntax of IFERROR IFERROR(value,value_if...
More