Quote:
Originally Posted by Kevin@Radstock
You will need to have a table set up in your work sheet with the post codes listed and a area allocated to each code, As in the UK there are over a hundred. Then you could use a LOOKUP or INDEX & MATCH etc.
EG: =VLOOKUP(LEFT(Cell/Ref,2),Your_Range,Column,0)
|
Thank you very much I will try and let you know how this goes.