Try:
=IF(Your_lookup()="","",You_lookup())
of, if it currently returning an error because the lookup value doesn't exist, then
=IFERROR(Your_Lookup(),"")
Try:
=IF(Your_lookup()="","",You_lookup())
of, if it currently returning an error because the lookup value doesn't exist, then
=IFERROR(Your_Lookup(),"")
Ty nbvc
Bookmarks