Cross reference two worksheets to identify matches
It all came up as matches so it didn't work.
Would you recommend something else?
"JBeaucaire" wrote:
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.
|