Excel 2007 : Return all values from a column, based on multiple conditions

[Alyena]

How is it possible to return all values from a column, based on 1 condition in one column and 5 conditions in the other column?

Column A - list of people, column B - ABC, column C - XYZ. I need to return all values from the column A if column B = "C" and column C = "X" and "Y" and "Z".

Please, advice... Thanks!

[NBVC]

Maybe?

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down, after adjusting ranges to suit.

[Alyena]

Thanks for helping me again :-) But i can't really manage how to confirm only part of the formula with CTRL+SHIFT+ENTER? When i do it, then the whole formula is activated..

[NBVC]

Why only part of it? Maybe I misunderstood the dilemma.

Do you mean that column B needs to have a "C" in it, and column C needs to contain all 3 of X, Y and Z?

[Alyena]

Yes, you got it right. When i said only part of it, because in your suggestion seems to be activation with CTRL+SHIFT+ENTER only {"X","Y","Z"}.

[NBVC]

Those {} brackets are part of the hard-coding, you still would need to confirm the whole formula to get the { } around the formula....

... but anyway, I think you might want this instead:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down.

[Alyena]

Sorry for my lack of knowledge here... Let me give you an example, seems i am doing something wrong... :-(

[NBVC]

Try:

Please Login or Register  to view this content.

CSE confirmed and copied down.

[Alyena]

It's working, but not completely correctly - i am getting the same name multiple times...

[Alyena]

Ok, I did it now (used the last suggestion), was my fault... In my original data i don't have blanks, but text, which is invisible because of conditional formatting.

Thanks a lot for your help!!!