Category Archives: excel

find value in range in excel

=IFERROR(IF(VLOOKUP(B2,$A:$A,1,FALSE)=B2,”found”),”not found”) find value of B2 in range A:A , if the value is found it will print “found” if not “not found”.

Continue reading