title: Displaying a value of cell that is filtered
body: <p>I have a small problem. I cant find a way how to create a formula that would show a cell value on another page in a excel document.</p>
  
  <p>I have in (both values on both pages) cell one a text name and in cell two a number value.</p>
  
  <p>What would a formula look like if I want to show the value in the first page (value from second page cell two), when a column is text filtered to G9414B = the value of  G9414B would be displayed in a cell?</p>
  
  <p>Please Help if you know how. I cant get it to work.</p>
  
  <p><img src="https://i.stack.imgur.com/PXcXp.jpg" alt="enter image description here">
  <img src="https://i.stack.imgur.com/FBWi4.jpg" alt="enter image description here"></p>