A simple if formula

[silentcoates]

If I have list of names in column G (30 different names) and a list of names in column P (5 names).

I need a formula inserting in column L that looks at columns G and says if name in column G1 is in the list of 5 names in column P it displays Team Leader in column L. If it does not appear then it should show CSE.

can anyone help

 

[goblin]

Try using COUNTIF within an IF, i.e. If(countif(p15,g1)>0,"in list","not in list")

 

[barry houdini]

In L1 copied down column

=IF(ISNA(MATCH(G1,P$1:P$5,0)),"CSE","Team Leader")

I'm assuming your names in column P are in P1:P5