Thank you very much for your assistance.. 8-)


-----Original Message-----
=IF(COUNTIF(Sheet2!$A$1:$G$1200,A4),"YES","NO")

--

Regards,

Peo Sjoblom

wrote in message
...
I would like to set up a cell to look for a number match
for a cell next to it in another worksheet and over many
columns and rows.

Does the value in worksheet 1 cell A4 ever appear in
worksheet2 in any cell A1:G1200.

Basically to return an answer of YES or NO


.