title: How to access entire row by cell address or value in excel?
body: <p>I have two sheets in excel.
  <br />First is MarkSheet of whole class.
  <img src="https://i.stack.imgur.com/5ozuN.jpg" alt="enter image description here"></p>
  
  <p>And second is IndividualResultCard. 
  <img src="https://i.stack.imgur.com/4sC7x.jpg" alt="enter image description here"></p>
  
  <p>I place role number of student or it's cell address in IndividualResultCard sheet and want to access complete row record.
  <br />Please give me its formula.
  <br />Is it possible without visual basic procedure?</p>