Hi all,
I want to create a formula to return any values that match from a specific partial text. For example, in sheet 1 cell C1 contain specific make which TOYOTA. In column A there are list of all TOYOTA models such as TOYOTA CELICA, TOYOTA INNOVA, and so on. Then I want it
to return any values from column A that contain text "TOYOTA" in return in column D ( D1 = TOYOTA ALTIS, D2 = TOYOTA CELICA ) Similar with this, then if I write "MAZDA" in cell E1, I want it to return value in column F ( F1= "MAZDA RX7").
Make
A
TOYOTA ALTIS
TOYOTA CELICA
MAZDA RX7
HONDA BRIO
TOYOTA DYNO RINO
C
TOYOTA
D
return value for column A in row1
return value for column A in row2
return value for column A in row5
I'm trying using =INDEX(A:A,MATCH("*"&$c$1&"*",A:A,0)+1). then drag down to see that "+1" could be automatically adjust to "+2". But it seem doesn't work.
Thanks in advance for your support .
Bookmarks