View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default MATCH does not work on a UDF-generated array

I omitted the closing bracket (in my previous post)

=MATCH(X6,index(F(x),,2)


=MATCH(X6,index(F(x),,2))

Glad you got it working

Regards,
Peter T

"pinkfloydfan" wrote in message
ups.com...
Perfect!

Thanks a lot Peter