| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match using array of column and row references to match with | Excel Worksheet Functions | |||
| Having trouble getting MATCH to work with a variable lookup array | Excel Worksheet Functions | |||
| Can't get array formula to work in MATCH function | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Error Generated from Array formula | Excel Programming | |||
Threaded Mode
