How to access entire row by cell address or value in excel

Question

I have two sheets in excel.
First is MarkSheet of the whole class. 

And second is IndividualResultCard. 

I enter a student's role number or cell address on the IndividualResultCard page and I want to view the entire row record.
Give me the formula, please.
Without using a visual basic process, is it possible?

Answer 1

You may accomplish all of this by using the Roll No. as your reference; utilise a VLOOKUP to do this.

Enter the following cells using my formula in Sheet IndividualResultCard:

C7 (name) paste =VLOOKUP($C$6,[MarkSheet.xlsx]Sheet1!$A$4:$H$100,2,FALSE)

C8 (father) paste =VLOOKUP($C$6,[MarkSheet.xlsx]Sheet1!$A$4:$H$100,3,FALSE)

Here I am changing only the col_index_num which is the column you wish to return in your MarkSheet.