Check to see if a value exists in a list?
in [Functions]
|
Prev: Why won't this function work?
Next: slope?
From: Pradhan on 11 Mar 2010 22:04 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
From: T. Valko on 11 Mar 2010 22:44 One way... =COUNTIF(A1:A3,B2)>0 -- Biff Microsoft Excel MVP "Pradhan" <Pradhan(a)discussions.microsoft.com> wrote in message news:D264540D-00D2-4F0B-BE8F-44DC6BC26B29(a)microsoft.com... > 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
From: Jacob Skaria on 11 Mar 2010 23:23 Try =IF(COUNTIF(A1:A3,B1),TRUE,FALSE) -- Jacob "Pradhan" wrote: > 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
From: Teethless mama on 12 Mar 2010 09:50 =OR(INDEX(A1:A3=B2,)) "Pradhan" wrote: > 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
From: Ashish Mathur on 14 Mar 2010 08:40 Hi,. Array enter the following formula (Ctrl+Shift+Enter) =B2=A1:A3 -- Regards, Ashish Mathur Microsoft Excel MVP "Pradhan" <Pradhan(a)discussions.microsoft.com> wrote in message news:D264540D-00D2-4F0B-BE8F-44DC6BC26B29(a)microsoft.com... > 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
|
Pages: 1 Prev: Why won't this function work? Next: slope? |