Need help with IF function

[Drazenka1973]

Hi,

Does anybody can help me with IF function.
I need IF function to set up with multiple values like this: IF (Cxx="items","Suplier","").
Explanation:

• Cxx should be C column (C1, C2, C3, etc)
• items should be like stamps, envelopes, papers, etc
• Suplier is just one name acctualy name of suplier like Nautilus

So if I put any of items (stamps, envelopes, papers,...) in column C I want excel to put name for supplier in column E. If there is a new item in column C leave column E empty.


THANX