View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Geoff Lambert Geoff Lambert is offline
external usenet poster
 
Posts: 3
Default MATCH() on a 2D array?

In Excel2003 is it possible to use something MATCH() on a 2D array, to
find the position of a particular entry? The result could be expressed
as a 2-element vector of {row,column} or as a single number
representing the "cell number" (e.g. in a 3x3 array, the middle cell
would be #5

Geoff Lambert