Are the values in one column also in another

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to find unpaired values at comparison of two columns 5
Help with VLookup 2
vlookup 1
Formula Dilemna 1
How to match values in one column to values in another? 3
Sum 7
Copy data to another column Macros 2
lookup taking only part of result 2

Top