Beginner Question I Think

[BeginnerXcel]

Hey guys,
I apologize if this has been asked but I am such a beginner I don't even know what this is called to search for it. So here is what I am trying to do. I have two columns of text information. I want to display the text of any matches in both columns. So basically a formula to search column A and B and then display any matches in Column 7. If the text "Math" and "Science" is in column A and B, it should display in the first two rows of column C where the formula is. Again, I apologize if this does not make sense or has been asked a bunch. Thank you for the help!

 

[arthurbr]

Hi
have a look at How to find common values from two lists | Get Digital Help - Microsoft Excel resource
that should do the trick

 

[BeginnerXcel]

Thank you very much! Common values is definitely the term I needed.