Getting a cell address with the INDIRECT function

Not sure if it's possible but how would I turn this into an INDIRECT formula, where the value in  [A5] is A6-EYK?

=ADDRESS(ROW('A6-EYK'!EndSeats)+59,COLUMN('A6-EYK'!X1))

Thanks,
John
LVL 1
John CarneyReliability Business Tools Analyst IIAsked:
Who is Participating?
 
barry houdiniCommented:
You could put INDIRECT in like this

=ADDRESS(ROW(INDIRECT("'"&A5&"'!EndSeats")+59,COLUMN(INDIRECT("'"&A5&"'!X1")))

regards, barry
0
 
John CarneyReliability Business Tools Analyst IIAuthor Commented:
Thanks, Barry! I needed to add one parenthesis after EndSeats but it works perfectly.

=ADDRESS(ROW(INDIRECT("'"&A5&"'!EndSeats"))+59,COLUMN(INDIRECT("'"&A5&"'!X1")))

I'm going to post another question about how to get the X1 dynamically, so please check back. I'll post a comment here with the link to the new question.

Thanks,
John
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.