Hello,

I have two columns of data - Column A has a list of stocks and Column B has names of stocks from that list that are private. I'd like to write an IF formula based on a Match statement that will show the word "Private" if a stock from the first list appears in the second list, and "Public" if not.

Any suggestions on how to do this?

Thanks for the help