The lookup value plus the supply facts are diverse details types. As an example, you are trying to own VLOOKUP reference a quantity, but the source information is saved as textual content. The IFNA perform returns the value you specify if a method returns the #N/A mistake benefit; normally it returns the result of the system. -forma excuse f