Help finding out if a set of values exists in a larger array of values

  • Thread starter Thread starter shadestreet
  • Start date Start date
S

shadestreet

I know how to use VLOOKUP, but I guess I dont get regular lookup.

Here is what I want to do.

I have a list of numbers in column A (about 4000).

I also have a list of 300 items that may or may not be included in th
list of 4000. I need to verify which items are and are not in tha
list of 4000. I thought a Lookup would help me in this, but it isn't.

What should I use? This isn't very difficult, maybe I am ove
thinking
 
Supposing that the shorter list is in column B from B2 on...

In C2 enter & copy down:

=--ISNUMBER(MATCH(B2,$A$2:$A$4000,0))

A 1 as result means: Found, a 0 Not Found.

You can also custom format C-range as:

[=0]"Not Found";[=1]"Found"
 
Back
Top