yes,
if the data to be checked is Text then
enter this into Cell M3 if data to be checked is in cell E3

=IF(ISTEXT(E3)=TRUE,"Y","N")

if Numeric then IF(ISNumber(E3)=TRUE,"Y","N")

"SiH23" wrote:

Is it possible to compare the data in each individual cell in Column E with
that in Column M. If the data in the cell in Column E is present in Column M
then place either a Y or N in Column J.

Many thanks.