You need to be a bit more explicit on what you want, but maybe something
like

=IF(OR(ISNUMBER(MATCH(A1,H1:H100,0)),ISNUMBER(MATC H(A1,M1:M100,0))),"matched
","not matched")

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)

"Mark" wrote in message
...
i would like to use an IF formula to query two ranges of cells (on
separate
worksheets in the same workbook) but don't know how to enter more than one
range in the formula. please can you help