Finding specific text in one cell and returning data from another

[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!

 

[Luke M]

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

 

[Luke M]

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

 

[Mike H]

Try

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

To make it case sensitive use find instead of search

Mike

 

[Luke M]

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

 

[Luke M]

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

 

[Luke M]

I apologize for the multi-repost. Server was being goofy.
=(

 

[Elkar]

Try this:

=IF(ISERROR(SEARCH("*JV*",A1)),"Not Found",B1)

HTH
Elkar

 

[Klee]

Luke, Thanks so much I really appreciate the help.