archana_ac

Q: search function only works in one cell

Hi,

 

I have 2 tables - table 1 and table 2.

I am trying to search for all values in table 2 column A in table 1 column B using the Search function. What i am trying to achieve is search for multiple strings within each cell of table 1 and show the rows containing the words.

 

Option 1:

The search function i have written is SEARCH(Table 2::A, B2) works in cell B2. But if i copy the same formula and just change the source string to B3, B4 etc, it gives an error message "Formula contains invalid reference".

Any ideas of how to resolve it.

 

Option 2:

Is there a way to use filters with dynamic text? i.e. use cell reference in filters?

 

Thanks,

Archana

iMac

Posted on Sep 13, 2016 6:16 PM

Close

Q: search function only works in one cell

  • All replies
  • Helpful answers