Lookup postcode zone from postcode

Hi all.

I am sure this has been asked before, but i haven't been able to find the answer that I am looking for, so hopefully someone has the solution to my problem.

I wish to be able to enter a postcode and get back what Zone the postcode belongs too.

In my excel i have 2 sheets, Data & Zone.

In the Zone sheet I created the Post code to / from (Column B & C) and what zone (Column A) it belongs to.
I named the 2 rages.
Column A = DK_Zone and Column B & C = DK


In the data sheet i have Country and Zone (Cell B1 & C1) Postcode (Postnr) (Cell B2) and then in Cell B3 I need to return the zone with a lookup based on the value in B2 (Postcode)
My problem it that Lookup also returs if the postcode is not in any From/to Range in a row?

i.e Postcode 8461 is not in any range, but it return zone "3"
I think the reason is that it looks at the postcode range as from smallest to Largest, but that is not what i am looking for.
I need it to look at every row "seperatly" and if the postcode is not in any from/to range in a row, it will retur a text "postcode does not exist" or something like that.

Hop someone is able to help me in the right direction.

Thanks

Soren