#IFError-Function

if you need to apply more than one criteria to get result during lookup. In that situation you have to use VLookup…