Return specific value IF specific text in cell

Hello!

Say i want A1 to show a the number 123, if A2 contains the text abc.

Wouldn't the function be:

=IF(A2="abc", 123)

Apparently this doesn't work. What am i doing wrong?

Thanks in advance! :)

Originally Posted by Ace_XL

Key word seems to be 'contains' here

=IF(ISNUMBER(FIND("abc",A2)),123,"")

Remember FIND() is case-sensitive. You might want to use SEARCH()

Thanks for the help, however it's not really working for me

I did it in this sheet https://onedrive.live.com/redir?resi...nt=file%2cxlsx

Can you tell me what i did wrong? maybe edit the mistake.

Originally Posted by Ace_XL

Key word seems to be 'contains' here

=IF(ISNUMBER(FIND("abc",A2)),123,"")

Remember FIND() is case-sensitive. You might want to use SEARCH()

Thanks for the help, however it's not really working for me

I did it in this sheet https://onedrive.live.com/redir?resi...nt=file%2cxlsx

Can you tell me what i did wrong? maybe edit the mistake.

Originally Posted by AZ-XL

Its just an alternative solution

=COUNTIF(A2,"*abc*")*123

Thank you! This worked.

Now i would just like to add something onto it. I also want A1 to say 234 if A2 says BCD.

How would those two functions look, next to each other?

Originally Posted by AZ-XL

Its just an alternative solution

=COUNTIF(A2,"*abc*")*123

Thank you! This worked.

Now i would just like to add something onto it. I also want A1 to say 234 if A2 says BCD.

How would those two functions look, next to each other?