Vlookup, Index, Match formula needed for a search criteria

[vikash200418]

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