find specific word from given phrases and find its assigned to whom?

General Excel Questions & Answers

2 Posts

2 Users

0 Reactions

59 Views

RSS

Hemanshu Mehta

(@hemanshumehta)

Posts: 1

New Member

Topic starter

Question 6
The data in column B contains a series of phrases. Every phrase contains one color in the phrase.
Basis the color in phrase in Column B, use the table in E10:F19 to assign the corresponding name from column F in column C.

eg
Phrases	Assigned to	Keyword	Assigned to
blue is my favorite color	Joe	blue	Joe
orange is my favorite color	Ralph	orange	Ralph

Phrases	Assigned to	Keyword	Assigned to
blue is my favorite color		blue	Joe
brown is my favorite color		red	Bob
I like his blue shirt		yellow	Mary
I like his brown shirt		pink	Fred
I like his lavendar shirt		orange	Ralph
I like his orange shirt		brown	Lora
I like his pink shirt		white	Tracy
I like his red shirt		lavendar	Earl
I like his white shirt		magenta	Jenny
I like his yellow shirt
lavendar is my favorite color
orange is my favorite color
pink is my favorite color
red is my favorite color
the ocean is blue
the ocean is brown
the ocean is lavendar
the ocean is orange
the ocean is pink
the ocean is red
the ocean is white
the ocean is yellow
white is my favorite color
yellow is my favorite color