Using an IF statement with INDEX / MATCH

Hi all,

I have an INDEX / MATCH formula that is currently looking at a value and returning some corresponding text:

Please Login or Register  to view this content.

I've now been asked to refine this to look at only data within the past 30 days. I've put this value in E6 and tried to use the following formula to look in only the specific dates (in column C):

Please Login or Register  to view this content.

...but this doesn't seem to work. I've also tried putting the IF statement beforehand:

Please Login or Register  to view this content.

...again no joy. I've tried running these as array formulas, but still nothing.

Can anyone suggest where I'm going wrong?

TIA,

FermentedR

Maybe try enclosing the If statement only on the returning value of the formula. If this doesn't work maybe you can attach the file and show the specifics. I will be back online later to see if you still need help. Have a look at the attached file and try this way of Index Match.