Put in say, H1:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(B1,{"NYSE:,";"NasdaqNM:,";"NasdaqS C:,";"Ame
x:,"})))0,"NYSE:NOK",IF(SUMPRODUCT(--ISNUMBER(SEARCH(B1,{"NYSE:,";"NasdaqNM
:,";"NasdaqSC:,";"Amex:,"})))0,G1,""))
Correction, apologies, got it the wrong way round
the formula in H1 should read:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"NYSE:,";"NasdaqNM:,";"NasdaqSC:, ";"Amex:,
"},B1)))0,"NYSE:NOK",IF(SUMPRODUCT(--ISNUMBER(SEARCH({"NYSE:,";"NasdaqNM:,"
;"NasdaqSC:,";"Amex:,"},B1)))0,G1,""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---