Forum Discussion

Copper Contributor

Sep 02, 2022

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

excel

OliverScheurich

Gold Contributor

Sep 02, 2022

Jamesboden

=VLOOKUP(LEFT(F4,1),$B$4:$C$16,2,FALSE)

Is this what you are looking for?

Jamesboden
Copper Contributor
Sep 02, 2022
Hey. Going to be honest, I only half understand this
- OliverScheurich
  Gold Contributor
  Sep 02, 2022
  Jamesboden
  Can you attach a screenshot of your sheet without sensitive data? I would try to adapt a vlookup to your requirement.
  - Jamesboden
    Copper Contributor
    Sep 02, 2022
    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.