Return value from another column

Hello everyone,

I am in need of a formula that will match the month (text) in column D1:D14 with column A1:A12 and return the value in column B1:B12.

Here is an example:
Screen Shot 2017-12-22 at 10.34.05.jpg

The formula in column E needs to do this:

Screen Shot 2017-12-22 at 10.47.22.jpg


So for example E10 has taken the month from D10 (August) and searched column A1:A12 to match the month string. A10 is a match and the answer is therefore B10 (Q4).

Example below:

Screen Shot 2017-12-22 at 10.51.38.jpg


I hope this makes sense. I have searched around and tried using Index / Match etc. but my Excel knowledge is not great. It will be interesting to see how to do something like this.

Thank you for any help

Try this in E1:

=IFERROR(VLOOKUP(TEXT(D1,"mmmm"),A:B,2,0),"")

then copy down.

Hope this helps.

Pete

Pete_UK

Perfect : )
I updated my date so that it is excel compliant (I took out the th from 30th June) and it works perfectly.
Thank you so much, I have been trying to solve this all morning and have been pulling my hair out lol.

Thank you so much, I really am very grateful.

Kind Regards,

Margate

You're welcome, glad to be of help. Thanks for the rep.

Pete