is there anyway to stop excel returning a FALSE message when searching a range? Formula below

=IF(AND('Data Deposit'!A2:A100= "First Name",'Data Deposit'!C2:C100= "Date"),TRUE,FALSE)

If the formula is searching a singular cell, e.g.

=IF(AND('Data Deposit'!A2= "First Name",'Data Deposit'!C2= "Date"),TRUE,FALSE)

The formula works, but a range doesn't. I think due to it returning other false messages, the false ones are overriding the fact that it has found one TRUE in the list.

Any help would be appreciated,

Thanks

Dan