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