You can use countif function

=countif(range of unique cells from sheet two,cell from sheet one)

If it returns 1 then it exists and if it's 0 then it doesn't.

Posted By: wobbly, Feb 24, 17:58:58

Written & Designed By Ben Graves 1999-2025