Vlookup, Index, Match formula needed for a search criteria

Dear Forum Members,

Thank you for helping us !

I need a excel formula. To explain my requirement I am providing a dummy data set. It has two tabs - Tab "Raw Data" has data and tab "Sheet1" where results are required.

In Raw Data - I have column for Code and 6 more columns which have Days name in them. All the cells might not have values in them.

Code	Days	Days	Days	Days	Days	Days
111	Sunday	Tuesday	Friday	Monday	Thursday
222	Sunday	Tuesday
333	Friday
444	Tuesday	Monday
555	Sunday	Thursday	Tuesday			Friday
111	Tuesday	Sunday	Friday		Monday
222	Friday		Monday			Thursday
333	Monday		Thurday			Sunday
444	Thurday		Sunday		Tuesday
555	Sunday			Thursday		Friday

Now in Sheet 1 - I have those codes and I have 7 columns for seven days name. I need to search each days name in a given column from the whole data set in the above tab against the given code and if found I need to pull the name in that column.

Code	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
111
222
333
444
555