View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bobs82
 
Posts: n/a
Default Excel OR function

I have trouble using an array as the argument in the OR function. I have
integer data in some of the locations in array (A1:T1). Unused locations are
blank. Ineed to know if any of the data in the array matches the integer
stored in,for example, C17. So far, everything I try leads to the #VALUE or
#NAME error message. What am I doing wrong?