I have a spreadsheet that looks up a area code from the postcode. I am using vlookup but it is giving incorrect answers. it works unless the postcode contains only 1 letter in the first set of characters. ie ne26 works bu n1 doesnt. is there a alternative to lookup?
I have attahced the spreadsheet.
Bookmarks