Searching for a value in a range

[a94andwi]

Hello.

I am trying to to lookup a value in a range just to see if it is there or not.
The function should answer with a simple true or false.

The value: 1 is in Cell C4
The range: AJ4:AS4

I think this is rather easy but I can't make it work for some reason.
IF( Checkrange (C4,AJ4:AS4),"True",False)
Checkrange should probably be some other function.

Can anyone help?

/Anders


IT worked.

Thanks a lot. Case closed!

[NBVC]

Try:

=ISNUMBER(MATCH(C4,AJ4:AS4,0))