I could really use some help with this headache.

I'm using Excel 2003.

I'm doing a Vlookup comparing text data in Column A of Worksheet 1 to text
data in Column C of Worksheet 2.
If there's a match I'm having the result placed in Column B of Worksheet 1.
When there's no match I get a blank which is fine.

I'm comparing about 10,000 records in Worksheet 1 to about 8,000 records in
Worksheet 2.

I need a way to get a count of only the matched records in Column B.

I've tried using the The CountA function for Column B, but I get the exact
same counts in Column B as I have for Column A in Worksheet 1, even though
only about 6,000 records matched. Is there a way to get this right? Excel
seems to count all of the cells just because there are formulas in every
cell in Column B.

COUNT doesn't work because I'm not using numerical values, and COUNTBLANKS
isn't finding any blanks in Column B!

Assuming there's a way to do this, I'll then need to compare the records
from Worksheet 2 to Worksheet 1 and get a count of those that match as well.

Thank you so much for your help....AJ