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

  • Thread starter Thread starter ship
  • Start date Start date
S

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
 
Strangely enough I have now discovered that the function =countif()
seems to work quite well!

Ship
Shiperton Henethe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What function returns the Nth position in a sequence of numbers? 4
lookup and return column number 2
How can I put a "slider" onto a spreadsheet (as a way of enteringnumbers) ? 4
How do I search for a string, without risking the "#value!" error? 5
Mathematical puzzle (for all you Excel experts) 13
Finding value using greater than, Vlookup, and nested If 2
Conditional format - how can I format a cell based on a DIFFERENT cell's value? 2
Return a value from one column using an array and a single row 1

Back
Top