Partial Match (In a Range)

[rob1963manwork]

Hello!

I am attaching a simple workbook with the following data:

1. Range A3:A6 contains a word or name
2. In Column D I have the actual data that contains a partial word match for that range.

I need a formula for column E (a helper column) that will tell me whether column D contains a partial match to any of the names in a3:a6.

I only know how to do this using the SEARCH function for when there is only 1 criteria. I get lost when there are multiple choices.

Does anyone have any insight to share??

Thank you!!

[AliGW]

Give this a go:

=IF(IFERROR(LOOKUP(99999,SEARCH($A$3:$A$6,D3),$A$3:$A$6),"")="","Not Found","Found")

[rob1963manwork]

Thank you, Ali!!!

I gave it a go, and IT WENT!

Your solution was on the spot.

[HansDouwe]

Yet another possibility:

Please Login or Register  to view this content.

[kvsrinivasamurthy]

In F3, then copy down.

Please Login or Register  to view this content.