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 the whole thing. Does anyone have any ideas please?

10 Replies

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.

Resources