Possilbe easy question

  • Thread starter Thread starter Confusicous
  • Start date Start date
C

Confusicous

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!
 
Try the below which starts from C45
=INDIRECT("'PSID Details'!" & ADDRESS(45,ROW(A3)))

If this post helps click Yes
 
Thanks! I appreciate it

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

If this post helps click Yes
Click to expand...
 
Back
Top