Bottom Line: I have a look-up list set that needs to reference information in a "sentence" to dynamically insert a result value (see example of data below), and I need to figure out a way to run a job over several lines int eh look-up table:
EX:
Phrases Assigned to Keyword Assigned to
the ocean is blue blue Joe
I like his blue shirt red Bob
The keyword/Assigned to columns are my vlookup (I believe) and I need to search rthe data in "Phrases" to distill the color, so I can add the "Assigned to" information.
the rules for this "test" are below:
The data in column A contains a series of phrases. Every phrase contains one color in the phrase. The goal of the challenge is to use the lookup table in D2:E10 to assign the phrase to one of the names in column E.
You can use a formula or a macro. The solution should be adaptable to any size data in column A and any length table in columns D:E. Yes, someone with Excel 2007 could nest 8 IF statements to solve the current problem, but this will not extend to a table with 34 entries, so this is not a valid approach.
I have attached the file - the correct tab is "Challenge 2"
Bookmarks