Lookup (or something)

[Dave Allar]

I need to take a value from one cell, and compare it against a column of
values, then display "Match" or "No Match", depending an the result.

I know ther must be a simple solution, but everything I've tried has failed.

Thanks,
Dave

 

[Peo Sjoblom]

One way

=IF(ISNUMBER(MATCH(A2,C2:C100,0)),"Match","No Match")

where A2 = one cell and C2:C100 = column of values

 

[Dave Allar]

Nevermind...

I used the CountIf function with an If statement and everything is fine now.

Thanks anyway!
Dave

 

[Andy Brown]

=IF(ISERROR(MATCH(value,match_range,0)),"No Match","Match")

Rgds,
Andy

 

[Dave Allar]

I was able to use the CountIf function and it worked wonderfully.

IF(COUNTIF(A1:A10,B1),"Match","No Match")

Thanks to everyone who helped!
Dave