BorisS wrote:

I had tried what you said, and it didn't produce any results. Not sure
what's wrong.

Maybe I didn't understand what you want to do, if you have 2 xolumns
with data and you have #N/A errors in A and want to display those and
the values in B then my method works


Regards,

Peo Sjoblom