All,

You're right. I didn't communicate my situation very well. I have a column
of campaigns. On the right of this column I have another column filled with
client names. Here's an example:
COL A COL B
jack camp1
barb camp1
jack camp2
camp2
jack camp3
joe camp3

In a different worksheet I have a column with nonduplicated campaign names.
i.e.:

Col C
camp 1
camp 2
camp 3

Now in yet another worksheet I have a column with the clients (no dups)
Col D
barb
jack
joe

Now I need get the information from the first two columns COL A and B into a
table in a new worksheet where the rows labels are the campaigns from Col C
and the column labels are from Col D. So, I need to be able to go down COLs
A & B, look at the entries, and then put a 1 in the proper location in my
table. This seems easy if I can use array indexes. Does that clear any
confusion? So yes, I do need to loop through the entries of COL A. The code
supplied so far by you guys makes sense and is helpful. I'm just not sure I
can fill the table in without indexes.

BTW, I am enrolled in a VBA class set to start this fall. So, I am RTFM = )
Until then though, thanks for all the help!!

Nate