I need help with a formula please thought I would post and hope one of
you guru’s can help. In my excel worksheet I have a list of 10,000
numbers going down a column and am trying to come up with a sum
product match formula

Example
A B C D E F G
1 0001 00 0 00 42
2 0002 00 1 11 39
3 6782 0 22 26
4 9400 00 1 33 42
5 5105 55 2 44 91
6 5551 55 1 55 01
7 2323 33 2
8 9999 99 0

Column A are the Numbers
Column B are the numbers I wish to Match
Column C Result of the formula if it is a Match
Column F and G are the VLOOKUP

I do understand the VLOOKUP will not work as I still need to count one
or two numbers which ever way thy appear (0042 or 24 result =2, 0048
or 84 result=1..Etc) this is way I had been working on the Sum Product
formula but cannot get it working

Thanks in Advance