Find specific text, in a string and retrieve that name according to a list of names

[fleyd]

Hi,

I am looking for a formula that searches in a cell for specific text listed on a range of cells, and if it finds something then retrieve that name.

It does not need to be case sensitive.

I attach a example file so it can be easier to understand my need.

ThanksFind specific text.xlsx

[FDibbins]

This ID's the matches, working on pulling out that 1 word
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH($D$3:$D$7,B3))))>0,B3,"")

[humdingaling]

CSE formula...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Please Login or Register  to view this content.

[FlameRetired]

Another way.

Please Login or Register  to view this content.

[samba_ravi]

C3

Please Login or Register  to view this content.

Try this and copy towards down

[shukla.ankur281190]

try
C3=IFERROR(LOOKUP(15^15,SEARCH($D$3:$D$7,B3),$D$3:$D$7),"") and drag down

[fleyd]

Thanks everyone for the help, fantastic formulas!!! this will help me a lot.

The idea is to make a budget sheet where i just have to copy my bank monthly extract, and it pretty much says where im spending my money with little efford and with little data inserting...

Thanks again.

[FlameRetired]

You're welcome. Glad to help. Thanks for the feedback and rep.