Cacher is the code snippet organizer for pro developers

// writes a 0 when VLOOKUP() returns an #ERROR
=IF(ISERROR(VLOOKUP(K3,$T$2:$U$47,2,FALSE)),0,VLOOKUP(K3,$T$2:$U$47,2,FALSE))