Want to return 'TRUE' if text duplicates in multiple cells

[ddub25]

Hello

I have a simple question. I have a list of 100's of different names in the A column and want to create a simple formula to see if certain names are present in the list.

In the B column I have a cell where I want to be able to type a name to check if it is present in the list. In the C column I have a cell that I want to return 'TRUE', if the name is present.

I am half way there using =EXACT (A1,B1). This returns 'TRUE' if the name I type into B1 is the same as the name in A1. However, I haven't managed to get the formula to work if I try and test to see if B1 is the same as any cells from A1 to A10000.

How do I create a formula for this argument? Thanks in advance.

ddub25

[starguy]

Hello

I have a simple question. I have a list of 100's of different names in the A column and want to create a simple formula to see if certain names are present in the list.

In the B column I have a cell where I want to be able to type a name to check if it is present in the list. In the C column I have a cell that I want to return 'TRUE', if the name is present.

I am half way there using =EXACT (A1,B1). This returns 'TRUE' if the name I type into B1 is the same as the name in A1. However, I haven't managed to get the formula to work if I try and test to see if B1 is the same as any cells from A1 to A10000.

How do I create a formula for this argument? Thanks in advance.

ddub25

Hi try this

=IF(ISERROR(MATCH(B1,$A$1:$A$1000,0)),"False","True")