title: Comparing two cells with two other cells in Excel
body: <p>OK, So here is what I am working on.  I need column BU:BJ to show a match with BM:BO and show it in column BU.  The first one in BH (BH2:BJ2) matches with the last row (BM12:BO12) and returns a 1 (true) in BU2.  So far so good.  What I need is if column BH does not match anything in column BM then show either nothing or something other then a 0 or 1.</p>
  <p>The formula I am using is =IF(IFERROR(MATCH(BH2,$BM$2:$BM$99)*MATCH(BJ2,$BO$2:$BO$99,0),0)&gt;0,TRUE,FALSE)</p>
  <p>Any help is appreciated.</p>
  <p><a href="https://i.stack.imgur.com/7bFUf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7bFUf.png" alt="enter image description here" /></a></p>
  <p>Need to look something like this in Column BU</p>
  <p><a href="https://i.stack.imgur.com/K8N1e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K8N1e.png" alt="enter image description here" /></a></p>