Hi,

I need to put a column letter in a cell (i.e. n), and then have the
formula refer to it as part of a cell reference.

More specifically, on the end of this formula, you will see n38 -
=IF($L38=OFFSET(AV38,-1,0),IF($C38=0," Amount?",$C38*N38),0)

So n in n38 needs to be a variable, where it picks up n from another
cell. Then I can do mass copying instead of copying and editing
hundreds of cells.

Much appreciated!

Michele