Look up to return a true/false value

W

WTG

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
 
Top