Names as per colour

[Shayeebur]

Hi
There are lot of names are given with the specific colour i have to find out whether this colour matches with the statment could u just solve this question.

 

[Somendra Misra]

Hi Shayeebur,

Use below formula in cell C11 and copy down.

=INDEX($F$11:$F$19,MATCH(1,--(ISNUMBER(SEARCH($E$11:$E$19,$B11))),0))

Note this is an array formula, so don't just press ENTER after writing the formula hit Ctrl+Shift+Enter.

Advise if any issue.

Regards,

 

[Shayeebur]

Thanx a lot somendra its working

 

[Somendra Misra]

Nice to hear that.

Regards,