Help with formula- need to update to search for certain word within text string

**blue.2025** · 05-27-2013, 11:20 PM

Hi,

I have a formula currently:

{=INDEX(Sheet2!$G$2:$G$8,MATCH($D$1&A2,Sheet2!$F$2:$F$8&Sheet2!$H$2:$H$8,0))}

however I need to update it as currently in D1 there is a description and then it searches for that exact description in Sheet 2 F, however I now have a scenario whereby the descripions are not exactly the same however they all contain the same word Post. So if I have the word post in D1 and need to somehow search for it in F within a sentence and then pick up the values.

Is there anyway this can be done?

**benishiryo** · 05-27-2013, 11:29 PM

hi blue.2025, welcome to the forum. you can try:
=INDEX(Sheet2!$G$2:$G$8,MATCH("*"&$D$1&"*"&A2,Sheet2!$F$2:$F$8&Sheet2!$H$2:$H$8,0))

but it's always better you attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**blue.2025** · 05-28-2013, 12:41 AM

Thanks that works - just come across a case whereby there are several rows with the word post for the same number and the formula only picks up the first one, is there a way to pick up all the items?post sample.xlsx

Hopefully the attachment worked!