Apologies I do not think I was clear in my question. The number changes throughout the row, so could be =Doors!$H$55*2 or =Doors!$H$55 or =Doors!$H$65 etc. Using the indirect function will it only change the letter ie the H to a J as example
Sorry not getting this.If my formula is =Doors!$H$55 throughout the row with the column number changing from 10 to 324 to pick up the various values but when I use the formula in different spreadsheets the row letter changes. I have never used Indirect function or place & in formula. Do I leave original formula in and somehow use indirect function or is it new formula of =indirect("doors!$H$"&55)
H is column and various rows are used, dollar sign as LETTER is constant down row.Sorry if I am not making sense burt as I said not understanding
Ok, going down the row my formulas are as follows,
The formula pulls the information from different sheet called DOORS and I have columns ranging from C to Y with different prices in each column. I then have pages with the names of doors example being Gresham and Gresham requires the pricing from column H. Another page is called Boston and Boston requires the pricing from column G. So the only change in the formula as I move along the pages is the letter. So as I move from the Gresham page to the Boston page I want to change the letter from H to G but in the column only not everywhere in sheet as would happen if I select the replace function.
I hope this helps.