• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If my cell has matching contain from list then output would be from another list.

Hello friends,

Good day.

I need your help in below situation;

workfile;
1716188420381.png

master-data;
1716188456107.png

I have 2 tables, 1 table is my workfile and another table is master-data.



The output I want is like below;

1716188603881.png


If the colum A1 (and so on) has matching word from table "I" then output in colum "B" must be colum "J".

Please anybody can help.

Thanks in advance to all my frnds.



Regards,
Khan.
 
a sample spreadsheet would be better here

is it just those 3 words
what if 2 or more appears
 
Try this.


=IF(ISNUMBER(SEARCH("*good*",A1)),"Band A",IF(ISNUMBER(SEARCH("*awesome*",A1)),"Band B",IF(ISNUMBER(SEARCH("*excellent*",A1)),"Band C","No Band")))
Hi iliyas,

Thanks you so much buddy....

101% it works... this is exactly I was looking for.....


@pecoflyer
@ETAF

Thanks to you guyz... for your helps...

But I think iliyas understood my query...



thanks once again.


as always regards,
-Khan
 
Back
Top