If Formulas

[Anne]

Help....

I am trying to write a statement that works out the
following...

Does the contents of Cell C1 equal the contents of any
cell within column A.

If it exists, display "yes" and if it doesn't exist
display "no".

I am having real trouble in trying to get this to work...

Can anyone help, I'm desperate!

Cheers

Anne

 

[Govind]

Hi Anne,

Try

=IF(ISNUMBER(MATCH(C1,A:A,0)),"Yes","No")

Regards

Govind.

 

[Alex Delamain]

A simpler version which also works would be:

=IF(C1=A:A,"Yes","No"

 

[Govind]

Hi,

I tried this as well, but it didnt work. In this formula the value in
cell C1 is not compared to each cell in column A.

Let me know if it works

Govind.

 

[Guest]

Hiya,

I tried both of these methods and neither worked....

I have the following values in a the rows:
A B C D E
289 700289 700 289 No

The formula for column E was as follows:
=IF(ISNUMBER(MATCH(D1,A:A,0)),"Yes","No")

And it returned "No" where I would expect "Yes"...

Can you help??

 

[Peo Sjoblom]

You have to look across instead of down

=IF(ISNUMBER(MATCH(lookupvalue,A1:Z1,0)),"Yes","No")

Regards,

Peo Sjoblom

 

[Alex Delamain]

Oops - thoght I had managed to remove my earlier effort before anyon
else spotted it did not work!

Here though is one that should

=IF(ISNA(MATCH(C14,A1:A36,0)),"No","Yes"

 

[Govind]

Hi,

You had mentioned Column A which runs from A1 to A65536. However your
example here shows that the data you have specified is in Row 1 which
runs from A1 to Z1.

Make sure you give your description of the range correctly.

Regards

Govind.