title: Creating search box in google sheet
body: <p>I am creating a search box on google sheet using =FILTER function. But my problem is it can only return the value in 1 column which is COL B. I want to know if it can return the data from column A as well? I tried to tweak the forumla but i am only getting errors.</p>
  <p>Here's the formula that I created.</p>
  <p>=filter(data!A2:B, SEARCH(D2,data!B2:B))</p>
  <p>Any inputs will be much appreciated. Thank you</p>