What is best way to determine whether a value exists in a column of values?

[ship]

Excel 2002


Hi

What is the best way to lookup a value (i.e. a number)
to see whether or not it is in another column of values?

I need exact matches only

I cant get lookup() to work...

With thanks


Ship
Shiperton Henethe

[ship]

Strangely enough I have now discovered that the function =countif()
seems to work quite well!

Ship
Shiperton Henethe