Quote:
Originally Posted by idxearo
Thank you very much I will try and let you know how this goes.
|
The formula suggested above will only look up the left 2 characters in the post code cells. That means it will look for EN in the lookup table rather than EN1.
The below will look for all characters before the first space.
=VLOOKUP(LEFT(CellRef,FIND(" ",CellRef)-1),Range,Column,0)