Quick Forumla Question

[cameronb]

I am developing a template and certain variables will be stored designated cells.

When using the below formula, how can I reference the varibles for column? e.g.

Formula in cell D3 =MAX(Datadrop!H:H)

The variable for the column will be stored in cell C3 and has "H" contained within it.

I am unsuccessfully getting an error with the below, can anyone assist?
=MAX("Datadrop!"&C3&":"&C3)

 

[baitmaster]

Try =MAX(INDIRECT("Datadrop!"&C3&":"&C3))

 

[cameronb]

Many thanks indeed!