I have some similar values in a1:a100 and b1:b100

I want to find the value in a1 if there in B1:b100. If yes means i want to
display yes and no means "NO" in some cell in c

Which formula can i use
--
srinivas

=IF(ISERROR(MATCH(A1,B1:B100,0)),"no","yes")

Regards,
Stefi

€žSrinivas€� ezt Ã*rta:

I have some similar values in a1:a100 and b1:b100

I want to find the value in a1 if there in B1:b100. If yes means i want to
display yes and no means "NO" in some cell in c

Which formula can i use
--
srinivas

"Srinivas" wrote:

I have some similar values in a1:a100 and b1:b100

I want to find the value in a1 if there in B1:b100. If yes means i want to
display yes and no means "NO" in some cell in c

Which formula can i use


Hi freind.... You can use this formula...

Select the cell where you want the result.
=if(A1:B1,"Yes","No")
after typing this you will get the result, then
drag the cell from extreme right bottom till where u want the solution..

--
srinivas

"vikram mundra" wrote:



"Srinivas" wrote:

I have some similar values in a1:a100 and b1:b100

I want to find the value in a1 if there in B1:b100. If yes means i want to
display yes and no means "NO" in some cell in c

Which formula can i use


Hi freind.... You can use this formula...

Select the cell where you want the result.
=if(A1=B1,"Yes","No")
after typing this you will get the result, then
drag the cell from extreme right bottom till where u want the solution..

--
srinivas

"vikram mundra" wrote:



"Srinivas" wrote:

I have some similar values in a1:a100 and b1:b100

I want to find the value in a1 if there in B1:b100. If yes means i want to
display yes and no means "NO" in some cell in c

Which formula can i use