If formula support

Hello

I am a school teacher and I have a list of the children's birthday in Column A

In column B I want to record their term of birth -

If Column A contains either September, October, November, December I want column B to return - Aut

If Column A contains either January, February, March, April I want column B to return - Spr

If Column A contains either May, June, July, August I want column B to return - Sum

I am not sure if I need to use a match index formula or an if formula

I was hoping someone could help. The system I get the d.o.b. from is in the format that I have included in cell A.

I have attached a sample excel page of what Column A looks like.

Mark

Try

Formula:

Please Login or Register  to view this content.

Nice approach Jacc.
But for LOOKUP function you don't need to avoid #VALUE error.
It will ignore it anyway.

So it's enought to use:

Formula:

Please Login or Register  to view this content.

and it's normal entered.

That's because mine approach return number (in search function) and then it find position of last number then return corresponding text (in F range).
You approach first generate text range from F column (based on TRUE/FALSE criteria of SEARCH function) and then you looking for last string.
That's why you need "big" text string (i.e. "zzz" or I prefere REPT("Z", 255) in LOOKUP to match last word.