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?