Yeah sounds like an IF/AND thingy.
=IF(AND(condition 1,condition2,condition3),Result if true,Result if false)
Can't say much else without knowing what the conditions are or how you want the information accessed and how it's organized.

mew!