Find cell value within table

[caroline]

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

 

[Dave Peterson]

Maybe =countif() would work:

=if(countif(a2:aa450,a1)>0,"it's there","nope")

 

[caroline]

yes good idea. Did not think about that one!!!
Thanks