Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of John Carney

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