Hi, see the attached document. I've used a formula:
for cell G3, why is'nt this picking up that there is 'Jan' in C3 and thus producing the value in D3?
View best response
In C3 you have a number, it's only formatting on the top. Use
Given that the expected result is a number, you may also use this Boolean formula: