View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Match() worksheet function

MATCH...

The lookup_array must be a one dimensional array.

--
Biff
Microsoft Excel MVP


"WCM" wrote in message
...
Excel Help indicates that the Match() function works for an Array, but I
can
only get it to work for a 'list' (i.e., does not work for an array with
more
than one column - does not work for a two dimensional array).

Am I missing something? Thanks in advance for you help ...

Bill