Hi everybody
if i have a tabel with
a : b
Apple : 1
Apple pie : 2
Tomato : 4
I want to make a table which returns me 1 & 2 below in seperate cells
to do that i have the following
=INDEX($C$2:$C$6, SMALL(IF(COUNTIF($B$8,"*"&$B$2:$B$6&"*"), ROW($B$2:$B$6)-MIN(ROW($B$2:$B$6))+1, ""), ROW(A1)))
Where B8 is the refence cell Apple
i wanted to include a wild card ( *Apple)
However that did not work
would anybody have an ide how to solve this ?
Bookmarks