Try

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

To make it case sensitive use find instead of search

Mike

"Klee" wrote:

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!