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