Given the formula
=IF(ISNUMBER(MATCH(AN2,$AG$2:$AG$65534,0)),"Matche d","Unmatched")

is there a way to have MATCH test a similar range on another sheet? Or am I
stuck doing this formula on two separate sheets?

Yes, this type of thing can be done in Access, but it would be so much
cooler if I didn't have to do that. And, no, installing XL 07 on this
computer is not an option.

Dave
--
Brevity is the soul of wit.