C1: cat
C2: dog
C3: chicken
C4: cow

your formula in D2

D2: =INDIRECT("C",ROW())
equivalent with =INDIRECT("C2")
It returns "dog"


"WINDMILL" wrote:

I'm not familiar with why / when the INDIRECT function is used.
I've inherited a spreadsheet, it has 10+ spreadsheets, and throughout them
there are several different scenarios of the INDIRECT functionm,this is the
simple one =INDIRECT("c"&ROW()). Would someone please explain in laymans
terms the purpose of using this function.
Much appreciated.