Refer to Column Location Variable in Formula

I'm looking to create a macro that will perform a "countif" function in a separate worksheet, to end up with a frequency distribution. As my macro is currently written, the "countif" formula depends on this particular column being in the same place every time in the Raw Data worksheet, but this isn't exactly a reasonable assumption. I'd like the macro to be able to *find* the column first and then refer to that specific location in the formula.

Here's what I have right now:

Please Login or Register  to view this content.

Of course, this doesn't work. Basically, I'm trying to get it to where the text that appears in the formula for the column reference (the "C[]" part of the formula) to use the column value that's returned in the "find" code above it. How do you refer to a variable name to act as a column reference within a function?

Any help would be appreciated. Thanks!