Solved: Supressing '#N/A' in WorksheetFunction.VLookup

Quote:

---

Originally Posted by mdmackillop

If #N/A is in the destination it will be overwritten by the lookup result. If the source contains #N/A as a string, it will appear in the result, but not if it is a calculated error value.

---

I haven't had the opportunity to look this over completely, but from a quick check, it looks to be exactly what I need. Thank you very much!:bow: