When doing data manipulation in Excel I frequently write vLookup statements, but “no match” ends up showing up as #N/A if you pass the FALSE parameter to the [range_lookup] option.

To avoid that, use a formula like this:


The ISNA() function is the key to detecting the #N/A values and then just substituting them with a zero length string (the two double-quotes).