Match formula
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
|