Search a range of numbers for group of numbers?

It sounds like you have a long list of numbers and you are trying to mark which ones are also found on a shorter list of numbers. There are numerous ways to do this. Here are a few.

The List table is a column of all the numbers you are interested in. 200 through 250.

Formula in Table 1::B2 =COUNTIF(List::A,A)>0

Fill down to complete the column

Those that are found will be TRUE. Those that are not will be FALSE.

Another formula would be

=IFERROR(MATCH(A,List::A,0)>0,"")

This will be TRUE for matches and blank for non-matches.

For your particular problem of all numbers from 200 to 250 you could do away with the second table and use the formula

=AND(A>=200,A<=250)

This would be much much faster if Table 1 has a whole lot of rows.

So, if your problem is as you stated (often this is not the case), this would be the recommended method

You can filter or sort the table by column B to gather up all the matching rows

It’s not clear if your second range is a unique list with one number in each cell.

if it is, you can use any lookup function to determine IF it is found. Or COUNTIF to determine if it shows up in the list how many times

if you want to know what row it shows up on, you can use the MATCH function, which will return the item number in the list.

remember that a lookup function will return the first item if finds, if you want to know if it shows up multiple times, then you need to do a COUNTIF.

jason

My first reaction on reading your question is that, if you really have a million numbers, then Numbers is not the tool to use! Excel might be able to handle such a large dataset.

SG