Input text in one cell and it populates another cell with different text

I apologize ahead of time for being confusing. I can clarify if needed.


I pretty much need a contingency spreadsheet to help me make decisions of people.

I want cell C12 to populate with a certain name based on the names being populated in cells C2:C11.

The formula in cell C12 I have tried but only gives me that one answer to one question: =IF(C2="BOB","JOHN","BOB")
So if C2 is populated with "BOB", then C12 will show "JOHN", but if it does not say "BOB then C12 will say "BOB."

I have been unable to get this to work but I would like the IF formula to let me pick the range of cells to do the text search and if the name I am looking for is there it will give me a text output I choose.

This is the formula that will not work:
=IF(C2:C11="BOB","JOHN","BOB")




This is only an example:
Capture.JPG


Thanks so much!