Hi Mike,
That did the trick! But…. Sorry to be such a pain…. when the lookup data is not found it will return the lookup data as a result. Is it possible to return a blank cell when the lookup is not to be found? Thanks a million!
Marc