Excel help

PostExcel help by **qupe** » Thu Jan 19, 2017 4:10 pm

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.

PostRe: Excel help by **Errkal** » Thu Jan 19, 2017 4:26 pm

I think this matches mostly what you mean.

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

PostRe: Excel help by **Rhubarb** » Thu Jan 19, 2017 7:09 pm

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?

PostRe: Excel help by **Errkal** » Thu Jan 19, 2017 7:15 pm

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

PostRe: Excel help by **qupe** » Thu Jan 19, 2017 7:23 pm

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

Excel help

Who is online

Affiliates