=IF(A1:A20="John","John","Tom")

Do you test the formulas that you post?

Biff

"Teethless mama" wrote in message
...
=IF(ISERROR(VLOOKUP("Tom",A1:A20,1,0)),"John","Tom ")
or
=IF(COUNTIF(A1:A20,"John"),"John","Tom")
or
=IF(A1:A20="John","John","Tom")


"jenhow" wrote:

I think this has an easy fix, but I can't seem to get my head around it
right
now.

I have a column of data which has a variety of formulas in it that return
a
variety of words. I would like a way to know if two certain words are in
that
column. If they are, I want to know which word is present. Here is an
example

Bob
Mike
Tom
Alan

I want to know if it says "John" or if it says "Tom" and it to return
which
name so my final result here would be "Tom". My data will never have
both a
John and a Tom in the same column, but Tom or John could be in row 3 or 4
or
5, etc.