Locate value in a range
We can get the full 2D address using Bob's formula. In Bob's example the
array was A1 thru L30. Say "XXX" is in cell C13. In cell A31, enter Bob's
array formula:
=MIN(IF(A1:L30="xxx",ROW(A1:L30)-MIN(ROW(A1:L30))+1,"")) this displays 13
In some other cell, enter:
=MATCH("XXX",INDIRECT(A31 & ":" & A31)) this displays $C$13
--
Gary''s Student - gsnu200824
"Matt" wrote:
I'm trying to locate a value in a range that is 12 x 30. Since its
not just a row or column I can't use match. Is there a way to use
match in "2D"?
Thanks!
|