Cell Formula

[Mike H]

I need an Excel 2003 formula: If the first cell contains the letter Y then a
second cell will display a name contained in a third cell - The second cell
needs the formula.

 

[Joe User]

I need an Excel 2003 formula: If the first cell contains
the letter Y then a second cell will display a name
contained in a third cell - The second cell needs the
formula.

If "Y" will be the entire cell value, then in the second cell (A1 and A3
represent the first and third cells):

=if(A1="Y", C1, "")

Note that this returns the null string ("") if A1 does not contain "Y", a
condition you neglected to cover.

If "Y" will always be the first character of the cell, then:

=if(left(A1,1)="Y", C1, "")

If "Y" might be anywhere within the cell, and you want to recognize "y"
(lowercase) as well, then:

=if(isnumber(search("y",A1)), C1, "")

If you want to recognize only "Y" (uppercase), change SEARCH to FIND, and
change "y" to "Y". But note that the other two formulas recognize match "y"
and "Y". See the EXACT function if you need to distinguish between them.

 

[Dave Peterson]

=if(isnumber(search("y",A1)),A3,"No Y")
=search() is not case sensitive (Y and y will both be ok).

If you need to match case, use =find() instead of =search().

Another non-case sensitive way:
=if(countif(a1,"*y*")>0,A3,"No Y")

I'm checking A1 and using the name in A3. My formula was in A2.