I want to find Client in Column A, and then if it finds Client it enters 'N/a - Client' in corresponding row in Column C. But as well as looking for client i want it to look for Intra (still in Column A), and similarly if it finds intra enter 'N/a - Intra' in corresponding row Column C..... basically do this code for multiple entrys. i thought of using OR command but it didnt work

Thanks in advance

Here is the current code:

Sub phillips()
[C1:C1000]=[if(search("Client",A1:A1000)=0,"","N/A - Client")]
end sub