ExcelBanter - Possilbe easy question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Possilbe easy question (https://www.excelbanter.com/excel-discussion-misc-queries/244448-possilbe-easy-question.html)

Confusicous

Possilbe easy question

here is my "formula"

='PSID Details'!C45

My question is how do I get it to where if I drag the formula down it will
go like
='PSID Details'!D45
='PSID Details'!E45
='PSID Details'!F45
='PSID Details'!G45

Thanks for the help!

Jacob Skaria

Possilbe easy question

Try the below which starts from C45
=INDIRECT("'PSID Details'!" & ADDRESS(45,ROW(A3)))

If this post helps click Yes
---------------
Jacob Skaria

"Confusicous" wrote:

here is my "formula"

='PSID Details'!C45

My question is how do I get it to where if I drag the formula down it will
go like
='PSID Details'!D45
='PSID Details'!E45
='PSID Details'!F45
='PSID Details'!G45

Thanks for the help!

Confusicous

Possilbe easy question

Thanks! I appreciate it

"Jacob Skaria" wrote:

Try the below which starts from C45
=INDIRECT("'PSID Details'!" & ADDRESS(45,ROW(A3)))

If this post helps click Yes
---------------
Jacob Skaria

"Confusicous" wrote:

here is my "formula"

='PSID Details'!C45

My question is how do I get it to where if I drag the formula down it will
go like
='PSID Details'!D45
='PSID Details'!E45
='PSID Details'!F45
='PSID Details'!G45

Thanks for the help!

All times are GMT +1. The time now is 05:22 AM.