Thread: Match formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bob
 
Posts: n/a
Default 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