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

Here's another way...

=CELL("address",INDEX(Table,MIN(IF(Table=D1,ROW(Ta ble)-MIN(ROW(Table))+1)
),MATCH(D1,INDEX(Table,MIN(IF(Table=D1,ROW(Table)-MIN(ROW(Table))+1)),0),
0)))

....where D1 contains the lookup value. Note that the formula needs to
be confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Geoff Lambert wrote:

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