Farhad,

Thank you very much. Well done. This will be a great help.

Regards Peter.

"Farhad" wrote:

Hi,

Here is the correct formula:

=IF(D9=U2,"GRANT PICTON",IF(F9=U2,"PAUL BELL",IF(H9=U2,"PETER
HUWILER","")))

Thanks,
--
Farhad Hodjat


"PeterH" wrote:

I am trying to setup a formular to bring in a persons name if a symbol is
entered into 1 of 3 cells, I have "Smilley" symbole in cell "U2" & the
formular I am trying is:
=(IF(D9=U2,"GRANT PICTON","",(IF(F9=U2,"PAUL BELL","",(IF(H9=U2,"PETER
HUWILER",""))))))

Need Help.