On Wed, 19 Mar 2008 10:02:04 -0700 (PDT), Dave F wrote:

Given the range H5:S5, how can I have Excel return the cell address of
the first value that appears in that range.

=MATCH(1,--(H5:S50),0) entered as an array formula returns 4; this
value is in cell K5. How can I get that cell address returned?

Thanks.

Dave


=ADDRESS(ROW(H5:S5),COLUMN(H5:S5)-1+MATCH(TRUE,len(H5:S5)0,0))

entered as an **array** formula.

It could be simplified to:

=ADDRESS(ROW(H5),COLUMN(H5)-1+MATCH(TRUE,len(H5:S5)0,0))

or even:

=ADDRESS(5,7+MATCH(TRUE,len(H5:S5)0,0))


depending on your specific requirements.
--ron