Searchable Expression

[mphekin12]

Hello,

I have the following expression in a Straigh Table:

=if(PPV.ProductID=ProductID, 1
     ,if(PPV.ProductID=PU.ProductID, 1
          ,if(PPV.ProductID=PQ.ProductID, 1
               , 'No Match'
          )
     )
)

I am trying to make it searchable so I can see all non-matches.  When click the 'Search' icon and type *No Match* nothing happens.  Did anyone else ever experience this issue?  Can anyone offer any advice on how to perform this search correctly?

Thanks!

[#2]

i'd say use applymap function in your load script, then it will definitely be searchachle.

[mphekin12]

nicksatch,

Thanks for the suggestion, but the applymap function will not work for me in this instance.

Does anyone else have any other suggestions?

Thank you!