Hi,

=IF(COUNTIF(Sheet4!A$1:A$100,A1),"Yes","No")

I entered this formula on the first sheet in cell B1. Copy it down as needed.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"drew" wrote:

I have data on the first tab that includes a unique ID #. I have a list of
ID#'s on a fourth tab that I'm trying to compare to list on first tab to let
me know "Yes" this ID is included from fourth tab or "No" Can anyone help?
Thanks!