Index partial match?

Hi,

I have this formula =INDEX('CTD Raw Data'!B:B,SMALL(IF('CTD Raw Data'!A1:K231="month",ROW('CTD Raw Data'!A1:K231)),2)) I am trying to match the word month in a cell that contains "1 month". If i add the number to the match it works fine but what I would like to do is a partial match ignoring the number as the numbers change frequently.

Thanks,

Originally Posted by AlKey

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

http://www.excelforum.com/excel-form...ial-match.html

This is not a duplicate post, the other one is a partial match left of a cell and recognizing a date as text. I dont know how to take that formula and change it into what i need to make the above scenario work! I almost got it with the above formula but im missing the partial match part.

I apologize I thought you were referencing another post. I didnt realize this posted twice as my browser glitched so i hit the back button and post again. Please remove this thread.