title: Excel - Auto populate a cell based on exact adjacent value (when having same names)
body: <p>I´m trying to get a cell to return the exact value adjacent to the item I´m searching for.</p>
  <p>Here is an example of excel work</p>
  <p><a href="https://i.stack.imgur.com/1f6DJ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1f6DJ.jpg" alt="enter image description here" /></a></p>
  <p>When introducing the second, or third ¨10¨, I want the H and G columns to show me the values next to the second or third ¨10¨, <strong>not the first values</strong>.</p>
  <p>So. when introducing the second ¨10¨ I want column H to bring up Bonnie M and column G to bring up 55555.
  Or <strong>the third ¨10¨</strong> to bring up <strong>$B6</strong> and <strong>$C6</strong>.</p>