Thread: Range? M1:Z1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default Range? M1:Z1

You could use match, which with 0 as the last argument will return NA if the
match fails:
=if(isna(match(f1,m1:z1,0)),"Not found","found")

"nastech" wrote:

Hi, can not remember how to see if 1 cell, is equal to same quantity in range
of other cells. Tried / to find: (thanks)

=F1=M1:Z1 getting ref error