Greetings all,

I have a certain situation that I need assistance with and would greatly appreciate the help.

I have an excel document with three columns: User Name, Question #, and Question Answer. So each row is a different question, but not everyone answered every question. I duplicated a small part of the document on sheet 1 of the attached document.

What I'm trying to do is on sheet 2. So basically I'd like a formula so that N2 would say "Something," M2 would say "Something else," C3 would say "Whatever," and so on.

I was wondering if that was possible and thank you so much for you advice in advance.

http://dl.dropbox.com/u/1198609/Example.xlsx

Thank you.