IF a cell contains specific texts!

[anuselesscharacter]

Hello,

I want help regarding a cell which contains specific text.

For Example:
If A1 contains 'Sent to Butwal' than return "Returned".
If A1 contains 'Sent to Bharatpur' than return "Returned".
If A1 contains 'Sent to Parasi' than return "Parasi".
If A1 contains 'Sent to Taulihawa' than return "Taulihawa".
If A1 contains any name rather than above mentioned words like (Jack, Ryan, Rajesh, Maria, etc) than return "Sold".
And if A1 does not contains any text i.e. blank/empty cell than return "Yard".

I'm currently using IF, ISNUMBER & SEARCH function. Below is the current sample that I tried which is incomplete. I want help with this formula.

Please Login or Register  to view this content.

[vba_php]

If A1 contains 'Sent to Butwal' than return "Returned".
If A1 contains 'Sent to Bharatpur' than return "Returned".
If A1 contains 'Sent to Parasi' than return "Parasi".
If A1 contains 'Sent to Taulihawa' than return "Taulihawa".
If A1 contains any name rather than above mentioned words like (Jack, Ryan, Rajesh, Maria, etc) than return "Sold".
And if A1 does not contains any text i.e. blank/empty cell than return "Yard".

if your example is literally literal, as in the input requirements would never change, you can just nest a bunch of FIND() functions together, can't you? and maybe use ISBLANK() and IF() as well?

Please Login or Register  to view this content.

[anuselesscharacter]

Thank You, it worked!