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:D264540D00D24F0BBE8F44DC6BC26B29(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:D264540D00D24F0BBE8F44DC6BC26B29(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? 