Find and report matching numbers in two worksheets
 

Hi

I'm still having trouble with this one.

I have a column of numbers from A1 downwards. In a second worksheet , I
have another lot of numbers in column A.

I need a formula which will tell me which numbers in Sheet1 are also
present anywhere in Sheet2 , and which aren't. Perhaps by marking
'Match' or 'No Match' against the numbers in Sheet1.

Any help appreciated.

Thanks.

Find and report matching numbers in two worksheets
 

Try this on sheet1 B1:

=IF(COUNT(MATCH(A1,Sheet2!A:A,0)),"Match","No Match")

Copy down as needed


--
Biff
Microsoft Excel MVP


"Colin Hayes" wrote in message
...

Hi

I'm still having trouble with this one.

I have a column of numbers from A1 downwards. In a second worksheet , I
have another lot of numbers in column A.

I need a formula which will tell me which numbers in Sheet1 are also
present anywhere in Sheet2 , and which aren't. Perhaps by marking 'Match'
or 'No Match' against the numbers in Sheet1.

Any help appreciated.

Thanks.

Find and report matching numbers in two worksheets
 

In article , T. Valko
writes
Try this on sheet1 B1:

=IF(COUNT(MATCH(A1,Sheet2!A:A,0)),"Match","No Match")

Copy down as needed



Hi

OK that's perfect. Worked first time.

Thanks!

Best Wishes

Find and report matching numbers in two worksheets
 

"Colin Hayes" wrote in message
...
In article , T. Valko
writes
Try this on sheet1 B1:

=IF(COUNT(MATCH(A1,Sheet2!A:A,0)),"Match","No Match")

Copy down as needed



Hi

OK that's perfect. Worked first time.

Thanks!

Best Wishes


Worked first time.

That's our goal!

You're welcome. Thanks for the feedback!


--
Biff
Microsoft Excel MVP