Hi,

I have a rather unusual problem here... Excel 2007. I also have Access
2007 if it would be better/helpful...

I have a spreadsheet containing all my volunteers' names, and the committees
they serve on (along with contact info, etc.). It's actually a
copy-and-paste from Outlook - the committte names are Outlook categories...

What I want to do is use the lookup function (or another way) to generate a
chart which would have my committees across the top, the members' names down
the side, and check marks showing which committee each member is on. For
example, it would say something like:

Board Executive Committee Strategic
Planning Committee
Tom x x
Joe x
x
Ralph x
x

So I need to look up Tom and see if Tom has the Board category - if so,
place a X there, if not, don't. Then see if Tom has the Exec category - if
so, place an x; if not, don't.

Any help would be appreciated!!