Emergency Ping: Excel Gurus

[Groundhog]

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.

[FrogMan]

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