Excel - address of cell containing text in a range

[osx99]

I have the following excel formula which works fine

=ADDRESS(MATCH(T2,A:A,0),1)

however I really need a formula that can look over a larger range eg A:M

the following returns #N/A

=ADDRESS(MATCH(T2,A:M,0),1)

Please can someone give some pointers how this can be achieved?

Thanks,
os

 

[SkipVought]

Use the MATCH function, one for each column reference.

MATCH returns an offset index or, as HELP states, "the relative position of an item in an array..."

Think about what VALUE that would be for A:M, if your lookup value were in M65536. (it would be 13 * 65,536, or 851,968) Would you know what to do with that number?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}