Finding specific text in one cell and returning data from another

  • Thread starter Thread starter Klee
  • Start date Start date
K

Klee

This seems like it should be easy but I can't seem to figure it out. I need
to look in one cell to see if it includes a certain word. If it does I need
to return the value from the cell next to it. For example:
Cell A1= JV meetings Cell B1=2.5
Cell A2+ conference on JV Cell B2=1.25

I need to find a formula that says if A1 "includes" the text "JV" then
return the value for B1


Thanks in advance!
 
Case sensitive
=IF(ISNUMBER(FIND("JV",A1)),B1,FALSE)
Non-case sensitive
=IF(ISNUMBER(SEARCH("JV",A1)),B1,FALSE)
 
Case sensitive
=IF(ISNUMBER(FIND("JV",A1)),B1,FALSE)
Non-case sensitive
=IF(ISNUMBER(SEARCH("JV",A1)),B1,FALSE)
 
Try

=IF(ISERROR(SEARCH("jv",A1)),"",B1)

To make it case sensitive use find instead of search

Mike
 
Case sensitive
=IF(ISNUMBER(FIND("JV",A1)),B1,FALSE)
Non-case sensitive
=IF(ISNUMBER(SEARCH("JV",A1)),B1,FALSE)
 
Case sensitive
=IF(ISNUMBER(FIND("JV",A1)),B1,FALSE)
Non-case sensitive
=IF(ISNUMBER(SEARCH("JV",A1)),B1,FALSE)
 
Back
Top