display content of a cell with conditions

[kirk]

I'm trying to create a formula that displays (even concatenates) the contents of a cell when two conditions are met. Any help?

Thanks, Kirk

[oldchippy]

Can you be a bit more specific?

[starguy]

I'm trying to create a formula that displays (even concatenates) the contents of a cell when two conditions are met. Any help?

Thanks, Kirk

make formula like this

=if(and(condition1,condition2),cell,"")

or with more detail

=if(and(A1="good",B1="evening"),A1&" "&B1,"")

Regards.

[kirk]

I'd like to display the name of a resource (column A) if they have a certain skill set (listed in column C) and any value in column E.

~Kirk

[starguy]

I'd like to display the name of a resource (column A) if they have a certain skill set (listed in column C) and any value in column E.

~Kirk

try this in (say) col F and copy down

=if(and(A1="name",C1="skill",E1="any value"),A1,"")

change "name" to a name of resource, "skill" to a proper skill which you want to match and "any value" with value that you want to be in col E against that name.

hope this would help you.