The last solution will give you a 0 instead of #N/A if not found to hide those, format those cells as custom: 0;-0;;@