Searching for multiple terms in a cell

[hermanblau]

I am looking to search each row in "Sheet1" for any of the zip codes located on "Sheet3" and to mark that row somehow - either highlight it or say "Yes" in column G. I have tried a variety of IF and OR formulas but can't seem to get it to work properly. Any ideas? My actual working document is attached.

Thank you, in advance, for the suggestions!

[Ron Coderre]

Using your posted workbook....
This regular formula, copied down, flags rows that contain at least one of the referenced zip codes

Please Login or Register  to view this content.

Is that something you can work with?

[perimidt]

Hi

For the first 1.148 rows this formula in G2 should work:
=IF(ISERROR(HLOOKUP(MID(D2,FIND("-",D2)-5,5)*1,Sheet3!$A$1:$EB$1,1,FALSE)),"","Yes")

From row 1.149 your list appears to change so your formula will have to reflect that:
=IF(ISERROR(HLOOKUP(MID(B1149,FIND("-",B1149)-5,5)*1,Sheet3!$A$1:$EB$1,1,FALSE)),"","Yes")

[hermanblau]

Thank you, Ron Coderre! That worked, and I believe that I can adjust the formula accurately for the other spreadsheets that I need to use. Thank you so much for the quick reply!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[hermanblau]

Thank you for the information, arlu1201!