Check to see if a value exists in a list?

[Pradhan]

Hi and thanks again for your help out there...
Is there any function to test if a particular value exists in a list?
A simple example: Column A1= car; A2=train; A3=plane

In B2 I place "car". Is there a function which will return TRUE if B2 exists
in A1:A3, or false otherwise?

Thanks
Pradhan

[T. Valko]

One way...

=COUNTIF(A1:A3,B2)>0

--
Biff
Microsoft Excel MVP

"Pradhan" <Pra...@discussions.microsoft.com> wrote in message
news:D264540D-00D2-4F0B...@microsoft.com...

[Jacob Skaria]

Try
=IF(COUNTIF(A1:A3,B1),TRUE,FALSE)

--
Jacob

[Teethless mama]

=OR(INDEX(A1:A3=B2,))

[Ashish Mathur]

Hi,.

Array enter the following formula (Ctrl+Shift+Enter)

=B2=A1:A3

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Pradhan" <Pra...@discussions.microsoft.com> wrote in message
news:D264540D-00D2-4F0B...@microsoft.com...