I have added two or more word in cells. and i have applied data validation.but i can not able to show second word during search.
I have attached screen shot for review.....
for example if i type centers or business instead of call, the full sentence should show.
please provide needful