View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WTG
 
Posts: n/a
Default 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