Using Indirect to pull in sheet name only

[smiffydotnet]

=INDIRECT("'"&A1&"'!"&B1)

This is my current formula.

A1 = the sheet name e.g. September
B2 = cell reference e.e D190

Is it possible to have D190 as part of the formula, so I only pull in the sheet name?

 

[Joe4]

Do you mean like this?

=INDIRECT("'"&A1&"'!D190")

 

[Misca]

Just add your fixed cell reference inside the double quotes:

=INDIRECT("'"&A1&"'!D190")

 

[smiffydotnet]

Thank you - a follow up question if I may....

If I fill down this new formula, is it possible of the D190 to be D191 on the next row down and then D192 and so on? Or do I have to just change this manually for each row?

 

[Joe4]

If I fill down this new formula, is it possible of the D190 to be D191 on the next row down and then D192 and so on? Or do I have to just change this manually for each row?

You can make use of the ROW() function to return the current row number that the formula is found in. As you copy down, that value increases. So you just need to add a value to get it up to what you want.

For example, let's say that the first formula is in row 2, and you want to return D190. Then enter this into the row 2 formula and copy down.
=INDIRECT("'"&A1&"'!D" & (ROW()+188))