Using wild card in IF formula

  • Thread starter Thread starter gcukarski
  • Start date Start date
G

gcukarski

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.
 
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
 
Try

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

This will not match Total but will match total
 
Back
Top