Inlist Function

[Oscar]

Is there a simple function that will return TRUE if an item is in a list and FALSE otherwise. I know I can do MATCH or VLOOKUP and then IF(ISERR..) sorta stuff; but it seems thre would be a more direct way.

thank you for your time.

Example

I have ist of names.

Billy
Bobby
Sally
Sammy
Ted
Tom
Clive
Bubba

and want to check if this name is on it:
Joe.

[lecxe]

Hi Oscar

You can also use countif

=COUNTIF(A1:A10,"Joe")<>0

HTH
lecxe

[Oscar]

Hi Oscar

You can also use countif

=COUNTIF(A1:A10,"Joe")<>0

HTH
lecxe

Hey! That's pretty cool.

I've used Countif and Sumif a lot; but never followed by the "<> 0".
Only used it to actually get a count or sum.

That is handy.

May you win the lottery.

carry on.