iWork
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