title: Excel > Find the correct data row
body: <p>I have an excel table with three pages. Page 1 will be a web-ran report, page 2 will be the DB report and page 3 is my comparison.</p>
  <p>What I am struggling to do or understand and find online, are examples of grabbing the staff number from let's say A2 on DB, comparing it to A2 on the web, and then grabbing their specific manager.</p>
  <p>The scripts I have made for comparison are;</p>
  <p>users not found DB to web
  <code>=COUNTIF(C:C, &quot;Not found&quot;)</code></p>
  <p>managers not found from DB to web
  <code>=COUNTIF(J:J, &quot;Incorrect&quot;)</code></p>
  <p>DB to Export Comparison
  <code>=IFNA(VLOOKUP(DB!A2,Report!A:A,1,FALSE),&quot;Not found&quot;)</code></p>
  <p>DB Team Manager check
  <code>=IFNA(VLOOKUP(Report!D2, DB!D:D,1,FALSE),DB!D2)</code></p>
  <p>Web Team Manager
  <code>=IFNA(VLOOKUP(DB!D2, Report!D:D,1,FALSE),Report!D2)</code></p>
  <p>Do managers match
  <code>=IF(F2=G2,&quot;Yes&quot;,&quot;Incorrect&quot;)</code></p>
  <p>How would it be best for the manager cell to grab the 'Staff Number' from the comparison page, locate it on the DB and then grab the manager in the cell next to it... and also in Web?</p>
  <p>Thanks very much!</p>
  <p><a href="https://i.stack.imgur.com/CNviI.png" rel="nofollow noreferrer">Comparison</a></p>
  <p><a href="https://i.stack.imgur.com/Nr4TN.png" rel="nofollow noreferrer">DB</a></p>
  <p><a href="https://i.stack.imgur.com/ejxJb.png" rel="nofollow noreferrer">repo</a></p>