To find an exact match, set the argument to FALSE. Note that using TRUE, which tells the function to look for an approximate match, can not only result in an #N/A error, it can also return erroneous results as seen in the following example. In this example, not only does “Banana” return an #N/A error, “Pear” returns the wrong price.