Combining Data from multiple sheets, plus tracking?

[mocp2008]

I'm learning so much as a member! Thanks everyone.

Here's my current question - I don't believe this is a difficult one, but what do I know?!

In Sheet1, I have ColA through ColH with data. In Sheet2, I have ColA through ColAA with data.

Now, I need to create a new sheet that combines the two based on values in ColC on both sheets. I upwards of 10K rows on each sheet.

I'll attach a (significantly shortened) example as a reply. I can't mess this one up - very important, lol.

Also, would there be an easy way to kick out a second sheet for at least sheet2 that adds a field with yes or no, to indicate if a match was found from Sheet1?

Any help!? Thanks!