Well, you can use VLOOKUP to return a binary code: 0 if VLOOKUP returns an
error, 1 if it finds the value. =IF(ISERROR(VLOOKUP([vlookup criteria]),0,1)

"If the VLOOKUP returns an error, then record 0, else record 1."

Dave
--
Brevity is the soul of wit.


"nkc_esquire" wrote:

how can i search a very long list of values to see if each individual value
in a shorter list is in the long list? essentially, i am trying to prevent
having to "ctrl-f" a thousand times...i don't need to return a value, like
vlookup does, i just need to see if the numbers in one list are in the other
list

thanks,
--
nate