Hi,

i have a table full of numbers. let's say it's 1000 by 1000.  I want
to see if this table has a set of specific values, say 100 i want to
check for.

rather than doing ctrl-f and find each of these 100 numbers, there
must be a smple find function in excel that will quickl check these
values, and return YES or NO, depending.

it seems as though there isn't such a simple function, VLOOKUP()
requires you to return a column index, search, or find use charaters,
Match only works with column data.

any ideas?

Phil