Can somebody explain, am trying to work this out...

I have a spread sheet, say on cell a2 will return the values only from the cell that I scroll down it , say it will match a18 or a112. The cell a2 will return the active cell value that am on

How did my friend do this