Matches for 50,000 rows

[stephme55]

Hello. I'm trying to do a match formula for 400,000 rows. Is there a better formula? if(match(h2,$d$2:$d$420,0),yes, no). Thanks.