GRcade

Can anyone help me please?

I want to create and excel spreadsheet where you have a box to enter a postcode. When you enter the postcode it checks a specific list and then i want a box below to display a message like east, west, north, south.

I am not sure what to do and what to search for.

I think this matches mostly what you mean.

https://www.mrexcel.com/forum/excel-que ... gions.html

Yeah presumably if you've already got the list of post codes and regions you can smash that in a separate table and it'll just be a vlookup using whatever value you enter?

You can download post codes from the post office is CSV etc.

Thanks both. This pointed me to the vlookup function and formula that worked a treat