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!