LOOKUP value inside a range of values

Hello and thanks in advance for help on this one.

I have attached a sample file.

I'm wanting to type into one cell, in this case J5.

Columns A to E are a table of data.
In columns B and C are a post code.
The post code entered in J5 should search the table, columns B and C, and identify which row is the post code range.
It should then populate cell J7 with the relevant "rating" in column E.

I've spent heaps of time trying to work it out but have failed.
Thanks in advance

This one?

Formula:

Please Login or Register  to view this content.

Or this one?

Formula:

Please Login or Register  to view this content.

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

I'm glad to have helped. Thanks for your feedback.

Please consider adding reputation to the answers of all helpers you think deserve.

EDIT: Thanks for the rep. .