I'm assuming you mean that if the range contains Germany *OR* Italy *OR*
France then return Y.

Try this...

=IF(SUM(COUNTIF(A1:J1,{"Germany","Italy","France"} )),"Y","N")

--
Biff
Microsoft Excel MVP


"woodson87" wrote in message
...
I'm trying to find in one of my rows of my excel spreadsheet specific
countries like Germany, Italy, France, etc. I need a formula that will
display IF one of those names occurs in that row, it will display a Y for
Yes. If it is not one of those names, I want it to display a N for No.