Microsoft Excel - Comparing columns in Excel worksheets

I'd like to write a formula or 'If...then' statement that checked if data in one column (the data is a unique code such as ULPR3000) existing in one column, can be found in another.

How would I write that please?

Hello Colette,

You can determine if this formula gives a value other than 0.

=COUNTIF($B$1:$B$10,"="&A1)

Harry