If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
comparing values for matches
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 |
#2
|
|||
|
|||
comparing values for matches
=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 |
#3
|
|||
|
|||
comparing values for matches
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 . |
Thread Tools | |
Display Modes | |
|
|