Forum Discussion
if, not - help needed please excel formula
I am sorry if this seems very simple but I am struggling , my hausnab used tio help me but he passed away during pandemic so I am fighting to do this I use this to tell me if date is a thusday to b...
For more flexibility, you might want to create a table like this
And then use this formula, here in cell A4, referring to the word in A2,
=VLOOKUP(A2,C2:D8,2,0)
The advantage of an approach like this is that you can change the days that may be listed, or not, by just changing an entry in column D. The formula remains the same.
I've attached a sample spreadsheet (below this message) showing that formula in action. You can test it by changing the entry in the yellow background cell.