Forum Discussion
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...
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.
