ExcelBanter - Find cell value within table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find cell value within table (https://www.excelbanter.com/excel-worksheet-functions/257275-find-cell-value-within-table.html)

Caroline

Find cell value within table

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

Find cell value within table

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

Caroline

Find cell value within table

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
.

All times are GMT +1. The time now is 02:33 PM.