find a value in a table

[Phil Newman]

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

 

[Bob I]

Someone will need to tell it at some point what to look for!