geordie_ben
Board Regular
- Joined
- Jul 27, 2009
- Messages
- 122
I've gotten a list of post codes and their counties.
This is how the data is presented:
<thead>
</thead><tbody>
</tbody>I need to do some type of lookup (I think), where the first part of a full post code being AB22 would show Aberdeenshire
Is there a type of formula I could use to do this?
This is how the data is presented:
Postcode area | Postcode districts | Post town | Former postal county |
---|---|---|---|
AB | AB10, AB11, AB12, AB15, AB16, AB21, AB22, AB23, AB24, AB25, AB99non-geo | Aberdeen | <small style="font-size: 11.9px;">(Aberdeenshire)</small> |
<thead>
</thead><tbody>
</tbody>
Is there a type of formula I could use to do this?