Forum Discussion

Jamesboden's avatar
Jamesboden
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's avatar
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's avatar
Jamesboden
Copper Contributor
Sep 02, 2022
Hey. Going to be honest, I only half understand this
  • OliverScheurich's avatar
    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's avatar
      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.

Resources