I have a spreadsheet that is due out very, very soon.

On one worksheet I have a list of usernames in column A, and in column B a list of functions assigned to that username:

ie:

groundhog | whatever1
groundhog | whatever2
joey | whatever1
joy | whatever3


Now, in another worksheet I have a matrix setup, with usernames running down column A, and the list of all functions running along the top.

ie:

username | whatever1 | whatever2 |whatever 3
-----------------------------------------------------
groundhog
joey


Now, what I want to do is have the above table populate by putting an 'x' under the function heading where it finds the function next to the username on the other worksheet.

I can't for the life of me figure it out, and have been screwing around with vlookup for the past hour with little success. :(

sorry for the delay, but I rarely cruise FOFC at 2:30am in case of excel emergencies ;)

Anyway, pm me an email addy and I can send you what I worked out. It's very hard for me to explain it here since I'm using a french version of excel, but all formulas will be all right once you open it with the English version on your end.

Just to say, I added a colum to your first table using the "concatenate" function, then vlookuped that one extra column.

FM