You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
you can probably vlookup this
so in a cell
=vlookup(a1, b2:e27310973091,1,0)
this means:
look up cell A1 in the table range b:e, return column 1, true match.
further:
if you have your postcode table in cell b2:e20000 (for example)
then in cell a2 write
=vlookup(a1,b2:e20000,1,0)
then type in a full postcode in a1.
a2 will return the matching postcode
you can then change the 1 to 2,3,4 to return the other bits of information you need.
Things you'll probably find:
your postcodes will need spaces removing.
it might be you only want to find a partial postcode - so FIND or SEARCH are good here
you might want to auto filter your data based on a cell, in which case you might want to convert your range to table