find adress

  • Thread starter Thread starter Jack Sons
  • Start date Start date
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
 
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
 
Sorry. Instead of TRUE in the formula I posted, use "A" *with* the quotes.

Alan Beban
 
Back
Top