Excel 2007 : Contrasting two sets of cells in the same row: problem with blank (null) cells

Hi everyone, I'm new, but not new to forums. I have one question, and I would be immensely grateful if someone could help me out with it.

The aspect of my dataset that is troubling me is structured as such:

Columns: Language 1(Country A), Language 2(Country A), ..., Language 5(Country A), Language 1 (Country B), ..., Language 5(Country B)

I want to define a new column that returns TRUE or FALSE values (or just 0, 1) for whether any one of the languages under Country A matches any of the languages under Country B. If at least one match = TRUE. If none match = FALSE.

The problem is that only (I think) two countries have five languages listed. So for the rest of them, there are null cells. But any formula I've been able to define with my limited Excel skills thinks that these null cells are valid, and matches them, returning me TRUE values inappropriately.

What can I do to get a formula that ignores null values in the rows?

Note that the language fields are text, if that is significant at all.

Any help at all will be greatly appreciated!