This will cover columns A - Z:

=CHAR(MIN(IF(COUNTIF(INDIRECT(CHAR(ROW(INDIRECT("6 5:90")))
&":"&CHAR(ROW(INDIRECT("65:90")))),"*abc*"),ROW(IN DIRECT
("65:90")))))

Array-entered, meaning press ctrl + shift + enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello everybody,

I'm looking for a formula (not VBA!) that could give me
back the letter of
the column containing some particular data (f.
ex. "abc").
If the data is present in more than one column, it could
give me back the
letter of the first column that matches the criteria (or
of any of them, if
it's easier).

Any help on this would be greatly appreciated!
Thanks in advance,

Mark


.