Look for 3 first digits in a list of strings

[ShayAA]

Hi,

I have a list of Zip Codes, and a list of 3 first digits to look for in the zip code. I'm having a hard time writing the formula to achieve it.

Please see the attached image as an example of what I'm looking for.

Thanks!

 

[ShayAA]

The list of strings to look for should be a range of cells, not specific cells. Thanks!

 

[FDibbins]

Cannot view your image, can you post a small sample here?

However, probably something like=match(A2&"*",B:B,0)

 

[ShayAA]

The photo is here: http://i.imgur.com/IxPMAyJ.png

 

[rence19]

="'"&left(A2,3)

 

[FDibbins]

Sorry, I an still not able to view images, can you post a sample here, please

 

[philaugust2004]

Try

=SUMPRODUCT(--ISNUMBER(SEARCH($E$1:$E$2,A1)))>0

 

[rence19]

=if(or("'"&left(A2,3)="010","'"&left(A2,3)="015","True","No true"))

Untested im using my mobile

 

[btorrean]

ShayAA,

Try pasting this formula in cell B2, and copying it down. Should be exactly what you want! This formula will also allow you to add or remove digits to look for in column D automatically. So you can look for less digit groups or more, just enter them as you please. Please let me know if you try this and/or it works for you.

=IF(IFERROR(VLOOKUP(LEFT(A2,3),OFFSET($D$2,0,0,COUNTA($D:$D)-1),1,FALSE),FALSE)=FALSE,FALSE,TRUE)

Brian

Brian J. Torreano