Finding specific text in one cell and returning data from another
 

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!

Finding specific text in one cell and returning data from another
 

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!

Finding specific text in one cell and returning data from another
 

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!

Finding specific text in one cell and returning data from another
 

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!

Finding specific text in one cell and returning data from another
 

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!

Finding specific text in one cell and returning data from another
 

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!

Finding specific text in one cell and returning data from another
 

Try this:

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

HTH
Elkar


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

Finding specific text in one cell and returning data from anot
 

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

--
Best Regards,

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


"Luke M" wrote:

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!

Finding specific text in one cell and returning data from anot
 

Luke, Thanks so much I really appreciate the help.

"Luke M" wrote:

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!