How can we only see results when they are NOT found?

[jtitus3]

I have a large CSV lookup table operational and working well but would like to run a search on my data that only shows values that are NOT in the table. Any ideas?
If no result is found, the default is “Definition Not defined”.
Thank you

[jtitus3]

After doing more research, what I really need is:
|stats count by Events |lookup EventList EC AS Events OUTPUTNEW Result AS MSG| (I only want MSG=Definition Not Defined)

[somesoni2]

Generally you could run a subsearch with your CSV lookup table to filter your indexed data (e.g. index=foo sourcetype=bar NOT [| inputlookup yourLookup.csv | table field1 field1.. | format]). With little information in the question about your lookup table, your indexed data search and their relationship, I would suggest give something like above a try. Providing more information in your question would yield you better suggestion from the community.