Input Postcode and Output Yes/No based on lookup

I have a postcode file (attached).

I want this file to have a userform that allows the user to type in a four digit postcode (numbers only) and the form will display "Yes" if that postcode is Remote or Very Remote according to the list of data in the Location tab.

If it's not Remote or Very Remote (ie. one of the other options) then the form should display "No".

If the Locality field happens to be blank or N/A or something not currently listed then the form should diplsay "No locality for that postcode"

I want the userform to be visible the entire time the workbook is open.

It can have either a button to check the postcode or be automatic if there are 4 valid digits entered.

Thanks

Thanks Kaper,

Works well, except for case when there is a zero as the first digit, eg. 0803

The "numbers" in Column A are actually text as some of our postcodes have a zero at the beginning.

Is there a way to modify the macro for these cases?

Sorry Kaper, I missed an error in your code;

Please Login or Register  to view this content.

All works great.

Thanks