From: woodson87 on 16 Feb 2010 19:19 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. From: Beverly on 16 Feb 2010 19:37 You can use "countif" for this. Here's how it would work: Row 1 = your data range Column A = the values you want to find Here's some sample data: Row 1 Column A (starting in row 2) Germany Germany Italy USA Austria France Hungary In cell B2, next to Germany, your formula would be: =if(countif(\$1:\$1,a2)=0,"No","Yes") Beverly "woodson87" wrote: > 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. From: T. Valko on 16 Feb 2010 23:12 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 news:F35CA68E-364C-4B7B-A730-B9FB9C58F334(a)microsoft.com...> 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.  |  Pages: 1 Prev: Find and Replace wildcardsNext: Formula for unique records