Conditional or VLookup?

I need to create a formula that will give me True or False if text in a cell matches any cells in a range.

For example:

Column A and B have text:

Account
Date
Name
Species

Column C has other and sometimes matching text:
Name
Deal

What formula would I use to find out if all cells in Columns A and B are represented in Column C?

Try:

=OR(Isnumber(Match(C1,A:A,0)),Isnumber(Match(C1,B:B,0)))

copied down

You are welcome.

Can you please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save