View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pinkfloydfan pinkfloydfan is offline
external usenet poster
 
Posts: 68
Default MATCH does not work on a UDF-generated array

Hi there

Can anybody explain why I have this particular problem?

I have written a UDF that outputs a 2-dimensional array. If this UDF is
called F(x) why does the following give a #N/A error?

MATCH(X6,F(x))

If I can't find a way to make this work then I guess I'll have to write
a UDF of my own to solve the problem.

Cheers.