How to express a column

[Red over White]

I am trying to isolate the letter 'w' in the following formula - =INDIRECT("Input!w"&$A$48) - and make it variable. The formula is being used in a different worksheet and column, in this instance 'n'. The idea is that if I have to put another column on either worksheet before the respective letter, then the formulas will automatically update.

Any help would be appreciated - thanks

 

[AgentSmith]

Formulae like this are often easier to write in R1C1 format, e.g.

= INDIRECT("Inputs!R"&A1&"C"&B1")

A1 = row number
B1 = column number

Does that help?

If that doesn't answer it then can you perhaps give a more detailed example of what you are trying to achieve? It may be possible to do what you need by an easier route.

 

[Red over White]

Thanks for your input, I have changed my formula to =INDIRECT("Input!"&Column!A23&$A$48) - where A23 is a list of letters with 'w' being in this cell. This makes the job of converting all the other formulae a lot easier. (I have created a similar column for the numbers). Both of these changes allow me to drag an updated formula, with the $s in the right place, to create a new formula irrespective of the direction I go in.

Thanks again