Look up to return a true/false value
Is there a function like lookup that will return a true/false value.
if this number on sheet 1 a1 is found anywhere on sheet 2 a1:a10000,
return a value of true or yes, if not return a value of false or no.
Thanks
Wally
|