Hi!

What result would you expect if these were the numbers:

a b c d e
1 3 7 1 8 0
2 3 6 3 4 8

Biff

"bob" wrote in message
oups.com...
hope i can get some help on this one
looking for a formula that looks into a group of numbers (8) and then
looks into another group of numbers (8) and returns a value if if there
are any matchs.

example
a b c d e
1 3 7 1 5 0
2 2 6 3 4 8 "result=1"
3
4
5

thanks in advance