find adress

J

Jack Sons

Hi all,

I have a matrix, say 19 rows and 16 columns. I know one of the elements is a
certain number, say 400, or a certain string, say abcba. I need an Exel
formula which results in the adress of that element, say $E$12.

I noticed that =match(400, A1:p19) will not work because it seems to work
only "per column". So
=match(400, E1:E19) will result in $E$12 but
=match(400, A1:p19) gives #N/A.

1) Why is this?
2) What is the formula I need?

Jack Sons
The Netherlands
 
A

Alan Beban

Perhaps someone will post a solution with built-in functions. In the
meantime, if the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, then

=ArrayMatch(400,A1:p19,TRUE)

Alan Beban
 
A

Alan Beban

Sorry. Instead of TRUE in the formula I posted, use "A" *with* the quotes.

Alan Beban
 
Top