Hi, I feel a bit dumb asking this question, I'm having a blonde moment. Anyway......
I want to check whether a name in cell A1 is in a list of names found in B1:B50. If it is, I'd like a Yes or better still a tick, if not a No or x.
I know this should be real easy but I can't get my round it.
Thanks in anticipation.
I want to check whether a name in cell A1 is in a list of names found in B1:B50. If it is, I'd like a Yes or better still a tick, if not a No or x.
I know this should be real easy but I can't get my round it.
Thanks in anticipation.