comparing values for matches

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you very much for your assistance.. 8-)

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

--

Regards,

Peo Sjoblom




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top