08-29-2008, 01:28 AM | #1 | ||
Coordinator
Join Date: Dec 2003
Location: Sydney, Australia
|
Emergency Ping: Excel Gurus
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: Code:
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: Code:
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.
__________________
Politics, n. Strife of interests masquerading as a contest of principles. --Ambrose Bierce |
||
08-29-2008, 07:48 AM | #2 |
Hattrick Moderator
Join Date: Jan 2003
Location: Pintendre, Qc, Canada
|
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
__________________
A Black Belt is a White Belt who refused to give up... follow my story: The real life story of a running frog... |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|