INDIRECT ---- Cell Value to Row Number

• Wanted to use the cell value as row number in one of the excel formulas.
• 3/7/17
• Use the INDIRECT function.
  
  If A1 holds 128, then
  
  =INDIRECT("C"&A1) will reference cell C128.
  
  Other ways...
  INDEX/MATCH
  OFFSET (e.g. =OFFSET(C1,A1-1,0) will work)
• Source: https://www.mrexcel.com/forum/excel-questions/56452-cell-value-row-number.html
• 
  

** When i tried to create dynamic formula i,e use variables in the function, i have come across INDIRECT function..

http://spreadsheets.about.com/od/tipsandfaqs/ss/2013-08-07-excel-sum-indirect-dynamic-range-formula_3.htm