How to Match name in a column cell to the name in anther workbook's column cell

[ecrodrig]

I am trying to verify that I have added all the necessary projects to a different spreadsheet. What I want to do is match the name on a particular column's cell to that name on the other workbooks column's cell.

Example lookup 123project in workbook1 within Column B and if you find a match output MATCH FOUND. Hope that makes sense