Part lookup


Hey Guys. Hoping someone can help. I'm trying to do a Vlookup for postcodes and what area they are. 

I need a Vlookup rule that will only search for the first one of two letters of the postcode, not the whole thing. Does anyone have any ideas please?


10 Replies



Is this what you are looking for?

postcode area.JPG 

Hey. Going to be honest, I only half understand this


Can you attach a screenshot of your sheet without sensitive data? I would try to adapt a vlookup to your requirement.

Problem I'm having is that when i do a standard lookup it only finds the first letter. So S for example is sheffield. So if I search for SO which is southhampton it still returns sheffield as that is the first letter. If that makes sense.

So basically, If I enter the first part of any postcode. Say SO I want it to return the area its is in.



You can try this formula. The ranges can be adapted as required.


Hey. this is fine. but I want to put in a full postcode AB1 1AA for example and it return an answer.



You can try this formula.

PO code area.JPG 

Yep thats the one. Thank you so much for your help.