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

's Computer Specifications

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

's Computer Specifications

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

Ship
Shiperton Henethe

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to determine min/max values of column	Fan924	Microsoft Excel Programming	3	29th Sep 2009 05:01 PM
Is there a way to determine if a column exists in a table?	=?Utf-8?B?Um9u?=	Microsoft Access VBA Modules	4	10th Oct 2007 10:25 PM
determine if value exists	=?Utf-8?B?Z2VlYmVl?=	Microsoft Excel Programming	2	19th Sep 2006 11:03 PM
Determine if Value in column A exists in Column B	TJKarakowski	Microsoft Excel Misc	3	19th Jul 2005 06:27 PM
How do I determine if a value in one column exists in another column?	Jim Berglund	Microsoft Excel Discussion	11	30th Jan 2005 07:24 PM