Are the values in one column also in another

  • Thread starter Thread starter ecimelli
  • Start date Start date
E

ecimelli

Hi there,

I'm sure this is a really simple function, but I just can't remember i
or find out how to do it via the help function in excel.

I have two lists. One long one on one worksheet, and one short one o
another worksheet. I want to know which values in the long list ar
also in the shorter list.

If anyone knows the formula/function I need, that would be fab.

Cheers,
Elen

Attachment filename: test example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54935
 
Back
Top