Link to home
Start Free TrialLog in
Avatar of John Carney
John CarneyFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of John Carney
John Carney
Flag of United States of America image

ASKER

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