Using wild card in IF formula
 

I have a list of names in Column A with values in Column B

A B

George 2
George 3
George Total 5
Adam 5
Adam 6
Adam 7
Adam Total 18


I need an IF formula in Column C that will look for cells in Column A that
have the word "total" in them. This is what I've tried and it doesnt work:


=IF(A3="*total*", B3, "")

Please help.

Using wild card in IF formula
 

Try this:

=IF(ISNUMBER(SEARCH("total",A3)),B3,"")

Search is not case sensitive - you can use FIND if that is important
to you.

Hope this helps.

Pete

On Sep 18, 9:54*pm, gcukarski
wrote:
I have a list of names in Column A with values in Column B

A * * * * * * * * * * * B

George * * * * * * *2
George * * * * * * *3
George Total * * *5
Adam * * * * * * * *5
Adam * * * * * * * *6
Adam * * * * * * * *7
Adam Total * * * *18

I need an IF formula in *Column C that will look for cells in Column A that
have the word "total" in them. This is what I've tried and it doesnt work:

=IF(A3="*total*", B3, "")

Please help.

Using wild card in IF formula
 

Try

=IF(ISERROR(FIND("Total",E19)),"",B3)

This will not match Total but will match total


"gcukarski" wrote:

I have a list of names in Column A with values in Column B

A B

George 2
George 3
George Total 5
Adam 5
Adam 6
Adam 7
Adam Total 18


I need an IF formula in Column C that will look for cells in Column A that
have the word "total" in them. This is what I've tried and it doesnt work:


=IF(A3="*total*", B3, "")

Please help.

Using wild card in IF formula
 

One more that uses wildcards:

=if(countif(a3,"*total*")0,b3,"")



gcukarski wrote:

I have a list of names in Column A with values in Column B

A B

George 2
George 3
George Total 5
Adam 5
Adam 6
Adam 7
Adam Total 18

I need an IF formula in Column C that will look for cells in Column A that
have the word "total" in them. This is what I've tried and it doesnt work:

=IF(A3="*total*", B3, "")

Please help.

--

Dave Peterson