Searching for multiple numbers at once...

[josel777]

Hello,

I am new to the forum. I am wondering if it is possible to search for
multiple numbers in Excel at once. Lets say I have a very large spread
sheet with part numbers and I want to find 200 specific part numbers.
Is there a way to search for all 200 part numbers at once, an have
Excel high light them?

Thanks in advance.

 

[Dave Peterson]

Maybe...

Is the data you're looking through a single column?

Do you have those 200 part numbers in a list somewhere (say another worksheet in
a single column?)

I'm gonna guess yes to both of these.

This is what I'd do.

I'd insert an additional column to the right of the column with all the part
numbers (say all your part numbers are in column A, then I'd use column B).

Then put the 200 part numbers in Sheet2 in A1:A200 (and nothing else in that
column!).

Then in with headers in row 1 of that first worksheet, I'd put this in B2:

=isnumber(match(a2,sheet2!a:a,0))

Then drag down the column.

Then select column B and do Data|Filter|autofilter. You can filter to show just
the TRUEs.

 

[josel777]

Thanks for the reply Dave. Unfortunately, the "isnumber" function i
unable to see my "part numbers" as numbers. Here is the nomenclature w
use:
02-049381-00. Any work around this

 

[Dave Peterson]

=isnumber(match(a2,sheet2!a:a,0))

=isnumber() isn't checking your part number.

It's checking to see if =match() returned a number or an error.

 

[josel777]

Got it. Thanks again