vasim
Member
In the formula
=Index(range1,small(if(range2=cell,row(range2)),row())
when dragged gives me the first cell match, second cell match & so on.... is it possible to get match that begins with or contains...something like
=Index(range1,small(if(range2=cell&"*",row(range2)),row())
=Index(range1,small(if(range2="*"&cell&"*",row(range2)),row())
Both the above doesnt work...any help
=Index(range1,small(if(range2=cell,row(range2)),row())
when dragged gives me the first cell match, second cell match & so on.... is it possible to get match that begins with or contains...something like
=Index(range1,small(if(range2=cell&"*",row(range2)),row())
=Index(range1,small(if(range2="*"&cell&"*",row(range2)),row())
Both the above doesnt work...any help