Find cell value within table
in [Functions]
|
Prev: Display information being cut short
Next: test if a logical statement and use the answer within an if statem
From: caroline on 24 Feb 2010 10:58 I would like to find if the cell value of A1 exists in table A2:AA450 I have tried with ISNA and Match but Match does not seem to work as I have more than one column and row: Match(A1,A2:AA450,0) returns #N/A Any idea? thanks -- caroline
From: Dave Peterson on 24 Feb 2010 11:02 Maybe =countif() would work: =if(countif(a2:aa450,a1)>0,"it's there","nope") caroline wrote: > > I would like to find if the cell value of A1 exists in table A2:AA450 > I have tried with ISNA and Match but Match does not seem to work as I have > more than one column and row: > Match(A1,A2:AA450,0) returns #N/A > Any idea? > thanks > -- > caroline -- Dave Peterson
From: caroline on 24 Feb 2010 11:45
yes good idea. Did not think about that one!!! Thanks -- caroline "Dave Peterson" wrote: > Maybe =countif() would work: > > =if(countif(a2:aa450,a1)>0,"it's there","nope") > > > caroline wrote: > > > > I would like to find if the cell value of A1 exists in table A2:AA450 > > I have tried with ISNA and Match but Match does not seem to work as I have > > more than one column and row: > > Match(A1,A2:AA450,0) returns #N/A > > Any idea? > > thanks > > -- > > caroline > > -- > > Dave Peterson > . > |