I am trying to use "IF" and "Match" function together to get values from a column. I just want to know how to get the corresponding values in case of IF function.
Example is attached in the excel.... If you see the example, in place of 1 in the column formula, I need the corresponding value from Column A. In C2 instead of 1, I want "Saturday" and in C3 instead of 1, I want "Thursday"..... In short, I want the corresponding value which match function finds and not "1"....
Bookmarks