When you say your function returns a 2D array do you mean multi row in two
columns.

If so the Match function needs a single row or column.

If you want to match say the second column of the array returned by the UDF
try

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

I assume X6 is a cell ref & x is a value being the UDF arg'

Regards,
Peter T


"pinkfloydfan" wrote in message
oups.com...
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.