title: Look up value in array and return all other values in row where the value is found
body: <p>I need to find a certain value in an array and return all other values in the row where that value is found. I tried several combined <code>INDEX, MATCH, VLOOKUP</code> array formulas but I'm no closer to finding a solution.</p>
  
  <p>Here's what I'm trying to achieve:</p>
  
  <p><a href="https://i.stack.imgur.com/4mzTY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4mzTY.jpg" alt="enter image description here"></a></p>
  
  <p>I'd like a formula to find the value in <code>G2</code> in the array <code>A2:E5</code> and then return all other values in each row where it's found to columns <code>H,I,J,K</code></p>
  
  <p>Any help pointing me in the right direction would be really appreciated ...</p>