Sep 02 2022 06:31 AM - edited Sep 02 2022 06:31 AM
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?
Sep 02 2022 06:38 AM
Sep 02 2022 07:11 AM
Can you attach a screenshot of your sheet without sensitive data? I would try to adapt a vlookup to your requirement.
Sep 02 2022 07:14 AM
Sep 02 2022 07:22 AM
So basically, If I enter the first part of any postcode. Say SO I want it to return the area its is in.
Sep 02 2022 07:41 AM
=VLOOKUP(D2,$A$2:$B$11,2,FALSE)
You can try this formula. The ranges can be adapted as required.
Sep 02 2022 07:50 AM
Sep 02 2022 08:05 AM
=IFERROR(VLOOKUP(LEFT(D2,2),$A$2:$B$11,2,FALSE),VLOOKUP(LEFT(D2,1),$A$2:$B$11,2,FALSE))
You can try this formula.