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

Luke M
*Remember to click "yes" if this post helped you!*


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