Here's the formula again, so you can see the piece clearly (internet breaks
things oddly sometimes). Just remove the line feeds at the end to make one
long line:

=IF(ISERROR(MATCH(
A2&LEFT(B2,FIND(" ",B2)-1),
Sheet2!$A$2:$A$400&
Sheet2!$B$2:$B$400,0)),
"No Match","Match")


--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.